Like almost everybody, i have a test and a live database. When I need to add a new table or view, I start by creating it in my test database and do all the coding. Once this all work, I redo every modificatons done to my test database to the live one (wich chances that I mistype something.)

Is there a better way to keep two databases in sync without actually doing things twice? Some of my tables have over 75 fields with long field name, so it quite time consuming creating them twice.

Simply copying the table is no good, since it allways want the original database. If I free it, I lose every field name that are longer than 8 characters.

How do you copy a view from one database to another?


TIA