I have multiple databases I use for testing purposes. My ideal structure is my live DB. I've added new tables and fields, etc to it, but haven't had the need to update some of the test DB's to include these new tables and fields. Is there a function/command that will update a non-empty test database to the structure of another (my live db) without overwriting the existing data?


My live database has a table called 'users', with 'firstName','lastName','password','logInDate','logInTime'

my test database table is identical, minus the 'logInTime' field.

Is there a way to add that field (and all other tables and updates) in one shot without emptying the DB and not using the ALTER TABLE statement?

Thanks in advance!