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 - 2004-01-13 : 07:59:32
|
| Farhat writes "Dear Sir I have my website which is developed by using ASP and with SQL Server Database. I need to make a utility in Visual Basic so that without using Enterprise Manager I can transfer the data from my PC to Remote Database server . can you help me ?with regardsFarhat Mahdi Dubai - UAE 00971-50-8434150" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-13 : 12:02:32
|
| You could use bcp.exe or dtsrun.exe to do the transfer. You could also just use BACKUP/RESTORE or DETACH/ATTACH to grab the entire database quickly. One more option is to use replication so that the remote database server always has the same data as your PC (minimal latency).Tara |
 |
|
|
|
|
|
Data Transfer in SQL Server 7