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 |
|
theghetto
Starting Member
1 Post |
 Posted - 2010-07-02 : 18:12:07
|
| What's the simplest way to automate the copying of a single table from one server to another (over the internet) on a nightly basis? Both run SQL server 2005 standard. The structure of the table will remain the same, but I'd like the data wiped and overwritten each night on the target server. Right now it takes about 2 minutes to copy the table when I use the import/export utility. Should I just save the package and attempt to schedule it? (no experience with that part of SSMS yet.) Thank you! |
|
|
|
|
|
automated table copy between servers