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 |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2011-08-12 : 19:54:47
|
| I would like to know how to copy data from the user acceptance test database server to my unit test database server. Both tables have the same format. I just need to obtain data to test with. The only way I can see to accomplish this task is to use the import wizard on the sql server 2008 r2 database. |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2011-08-13 : 06:08:51
|
| if you need this only one time you can use linked server and insert statement.or do you need as a mirror/backup to have a backup data? |
 |
|
|
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2011-08-13 : 17:09:19
|
| This is only one time. How do you use linked servers? |
|
|
|
|
|
|
copy data