Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Find difference Between two table strucutres

Author  Topic 

NamrataC
Starting Member

5 Posts

Posted - 2010-10-28 : 05:26:55
Hi All,
I don't know much about SQL. I have a task to be done, which is,
There are 2 databases, 1 is original and another is backup of the original database. Suppose I alter table structure in original database, I have to alter the table in backup database too. But my data in backup database must not be lost.
Please help me.
Thanking you in anticipation.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-10-28 : 05:38:37
"Check for Schematic Differences" a script provided by Transact Charlie

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=136699


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

NamrataC
Starting Member

5 Posts

Posted - 2010-10-28 : 07:46:24
This link was very useful.
My next task is to update the table structure with updated schema on finding the difference.
Go to Top of Page

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2010-10-28 : 09:07:26
quote:
Originally posted by webfred

"Check for Schematic Differences" a script provided by Transact Charlie

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=136699


No, you're never too old to Yak'n'Roll if you're too young to die.



Wow, thanks.
Go to Top of Page
   

- Advertisement -