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.
| Author |
Topic |
|
gfahrlander
Starting Member
23 Posts |
 Posted - 2003-06-02 : 11:05:33
|
| I need to know the best tools on the market for comparing data and structure differences between two SQL Server databases. We have a vendor that provides updated databases, stored procedures, etc. and need to know what changed between releases and ensure we don't lose any user data when applying the new releases. I've evaluated the Red Gate Tools (very nice) but I need to know if there are others with similar functionality.Thanks in advance,GaryNo trees were killed in posting this message. However, a large number of electrons were seriously inconvenienced! |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-06-02 : 11:29:09
|
| Structure is easy.Seewww.nigelrivett.comScript objects from all databases and save change history in SourceSafeThis will give you the changes and a history to keep.For the data - unless you have a small database then comparing all the data is going to take a long time but it can still be done without spending money by bcping out all the data. You can use a query sort the data and to keep the structure of the data the same for changed table structures.Nothing wrong with sqlcompare - I just prefer to do it myself so I know what I am getting.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy.Edited by - nr on 06/02/2003 11:30:23 |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-06-02 : 11:32:39
|
| I use SQLCompare. Best $200 I've spent in a long time.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
SQL Server Data & Structure Comparison Tools