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 |
|
petem
Starting Member
44 Posts |
 Posted - 2005-04-19 : 04:00:33
|
| Hi all,We have two databases on diferent servers. I quickly need to find out how to write a query to copy data from one table to an indentical table on a different server - (basically - make a test table up to date.)The table has an automatic ID field which may cause a problem....Any help much appreciated,Pete |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-04-19 : 04:07:17
|
| create a dts package, for the source, use query to specify which columns should be copied excluding the ID field--------------------keeping it simple... |
 |
|
|
|
|
|
copying from different servers