In theory I am thinking that as long as the structure change will accept the data that is already in the fields, you could set up a dts package that would look at the structure of one DB and possibly copy it another, not sure about keeping the data in it. If there is not a lot in your second DB, you may just try pushing that data to a temp table while it recreates the table with changes, then bring the data back in. I believe that may be the only way, but try the DTS thing, just make sure that you look at the script before you run it and make sure that it does not drop the table before applying changes. If you are successful in doing this, then you can just run that package anytime you want to make the updates.
Christian -----Original Message----- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 3:53 PM To: SQL Subject: Database Structure Replication I am using SQL 2000 Enterprise and was wondering if there is a way to replicate the database structure automatically when I make a change to one of the databases. I have a test database and a production database, both have different data but the same structure. Right now if I want to make a change I have to do it twice, once on the test and once on the production. Is there a way to replicate the structure and not the data also? if not, i can just keep the data synced i guess, but not really what i am wanting to do. Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
