June 4, 2002 at 11:47 pm
I want to compare all the tables in 2 databases (production and development) and if there are any differences like for example tables have been added or columns have been added or altered in anyway in the development database is there any way to update the production tables using DTS or if not TSQL?
I've tried copying of the objects accross to the production db in a DTS package from the dev db but there seems not to be anyway to do this without first dropping the objects and the problem here is that when the objects are dropped so is the data and naturally I want to retain the data in the production db.
Is there some sort of strategy I should be following for this or am I missing something in DTS..?
any help appreciated
June 5, 2002 at 4:57 am
Please do not cross post. Duplicate messgae please see responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4628&FORUM_ID=23&CAT_ID=2&Topic_Title=compare++tables+in+dbs&Forum_Title=General .
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply