>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


I have a utilitity here in the files section called genview (the download file is called gentable.zip) that receives a view name as a parameter and creates a programmatic definition of the view. With this definition in hand, you can open you real database and run the program and the view and all of its properties are ireplicated in the second database. The file gentable.prg does the same thing but for tables.