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 |
|
shasha
Starting Member
13 Posts |
 Posted - 2008-05-28 : 17:40:12
|
Hi, I was just wondering if there is an easy way to compare data from two separate sql ser 2005 dbs and let me know when there is a difference.. i have tried a few simple queries but just wanted to see if there is any code in vb already out there just waiting to be used. If not, can I write a query and make it automated as I ingest data? What would the query look like for an example... thanks for your help s |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-28 : 17:41:16
|
| To automate it, just use transactional replication. No queries needed as replication handles everything.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
shasha
Starting Member
13 Posts |
Posted - 2008-05-28 : 17:43:08
|
| thanks Tara..i will try that!! |
|
|
|
Zack
Starting Member
26 Posts |
Posted - 2008-06-02 : 15:00:22
|
| Download the free program SQL Server Compare from Yes Software (Google it and you'll find it easily). I use it all the time to compare db's between development and production. |
|
|
|
|
|
|
compare script