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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-17 : 08:39:54
|
| Aanand writes "I have to write stored procedure to copy the data from one database to other database.Both the database at the different machine and both are on different domain. If any one have solution then please help me regarding." |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-02-17 : 10:22:57
|
| Look at the copy SQL Server Objects task in DTS.. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-02-17 : 13:48:36
|
| Hi Aanand, Welcome to SQL Team!Any of these sound promising?Backup / Restore - possibly using log shippingReplicationBCP data out, FTP to other machine, BCP back in at other machineLinked server - then just use something like:INSERT INTO RemoteServer.RemoteDatabase.dbo.MyTableSELECT *FROM LocalDatabase.dbo.MyTableKristen |
|
|
|
|
|
|
Archive Service