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 |
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
 Posted - 2005-02-14 : 17:26:38
|
| I am not sure if this is even a DTS subject.I have a database at my office that needs to check to make sure that the Vendor IDs that it stores match the Vendor IDs that are stored in another database on a different server on a different domain. Currently, this task is accomplished via a person talking to another person over the phone. It seems like a simple thing for a SQL server to do behind the scenes. Both databases are SQL2000.I am not looking for specific code, but can you experts point me in a general direction? If I can get the two databases to talk to eachother, this is a simple query to make sure that the Vendor IDs jive with one another. Is this a DTS thing? Or is there a more direct way to do this through a Job? Thanks all!Aj |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2005-02-14 : 17:48:14
|
| Look up Linked Servers on Books Online.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-14 : 17:48:37
|
| You can do this via linked servers.This will show the differences:SELECT * FROM SourceDatabase.dbo.SomeTable t1FULL OUTER JOIN LinkedServerName.DestinationDatabase.dbo.SomeTable t2ON t1.SomeColumn = t2.SomeColumnWHERE t1.SomeColumn IS NULL OR t2.SomeColumn IS NULLTara |
|
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2005-02-18 : 11:52:24
|
| Thanks guys, this gives me what I need to move forward!Aj |
|
|
|
|
|
|
Please excuse my ignorance