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 |
|
djorre
Yak Posting Veteran
94 Posts |
 Posted - 2009-06-16 : 05:34:09
|
| Hi friends,In order to do some testing I'm asking myself what's the fastest way to copy all table values from one server to the other.I do not want to use triggers or replication. It's not needed for the database to be constantly in sync with the other, the only reason is to have (like every 2 hours) the latest table values in order to do proper testing. The testing server is not permitted to send it's adapted table values back to the 'running' server. Everything (IDs, UniqueValues...) needs to be the same. Plus I'm not sure the network connection is fast enough (4GB database). Backing up the database and restoring it takes already 1 hour. If I use the import tables tool, can the running server keep doing transactions while his tables export?Same question for doing a backup, can this happen savely?Any suggestions?Thank, Joris |
|
|
kishore_pen
Starting Member
49 Posts |
Posted - 2009-06-16 : 06:34:12
|
| try BCP command. |
 |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2009-06-17 : 15:22:32
|
| Backup -> Restore is probably the fastest. If your database is only 4GB and it takes an hour to restore, that doesn't sound very good. I have tables that are over 40GB and I can move them in a couple of hours. |
|
|
|
|
|
|
Fastest way to duplicate tables to other server