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 |
|
Elvira
Starting Member
4 Posts |
 Posted - 2010-11-22 : 02:36:45
|
| I am using SQL Server 2008. There are two Servers: 1)Active Server "Server1" 2) Server for storing not important data or old data "Server2".What the best way to Exporting old data from Server1 to Server2. For example: "Insert into Server2.t1 Select * from Server1.t1 where Server1.t1.dWhen <@from_date" |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-11-22 : 04:03:16
|
| Please ask your question jin the 2008 Administration forum...this forum is a repository for working scripts only.- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
|
|
|
|
Export Old Data