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 |
|
cardgunner
326 Posts |
 Posted - 2009-07-06 : 11:35:51
|
| We just upgraded to 2005 and we put it on a different server.So we now have 2000 on server A and the db is there as z2000db and 2005 is on server B and that db is z2005db. During the conversion some info didn't migrate exactly as it was. I need to find some of the crucial differences as well as migrate over some user created tables.I've been running one query in 2000 and exporting the results into excel. Then run same query in 2005 and export results into same work book. Then I line them up and look for differences. Not a perfect way.I've never had to join tables that existed on seperate servers. Is it possible? Is there a better way? CardGunner |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
cardgunner
326 Posts |
Posted - 2009-07-06 : 13:54:02
|
| What does setting up as linked server entail?I did not do the migration. It was done by our Operating System's provider.As an example I seen there was differences in a table that summarizes the details from another table. Fortunely the new summary table is correct and the old was was not. I don't have a ton of data to validate but when I do it would be nice to join one table from A to the same table in B and do an exclusion of equal info so I'm left with just the differences. CardGunner |
 |
|
|
|
|
|
Run a Query from db on different servers