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
 General SQL Server Forums
 New to SQL Server Programming
 compare data pls

Author  Topic 

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2008-06-09 : 17:45:52
was able to load data from 2005 to 2000 about 100+ tables. Now i'm only concerned about if data is the same the rows and data types (not sure if there is any difference). Any ideas how to test it? should i go row-by-row???? its over 100 tables. OH MY goood...

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-09 : 17:46:48
Check out the Red Gate tools that allow you to compare the schema and data. There's SQL Compare and SQL Data Compare.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2008-06-09 : 17:47:48
my version is expired.
Go to Top of Page

Haywood
Posting Yak Master

221 Posts

Posted - 2008-06-10 : 17:59:47
The Visual Studio DB Professional version has a data compare in it as well....
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-06-10 : 18:02:12
Also asked here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=104537



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

Haywood
Posting Yak Master

221 Posts

Posted - 2008-06-10 : 18:08:48
quote:
Originally posted by Peso

Also asked here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=104537



E 12°55'05.25"
N 56°04'39.16"




Nice code over there.

Go to Top of Page
   

- Advertisement -