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 |
|
moinul2007
Starting Member
2 Posts |
 Posted - 2009-01-14 : 05:12:49
|
| Hi All,We have a website running with SQL Server 2000 and hosted locally from our office premise using a broadband connection. We encountered slow bandwidth problem and now trying to host our website along with SQL database in a remote server in the USA for better bandwidth. By the way we are located in Dhaka.So far we have managed to create the database in the remote SQL server. But we are unable to insert our existing data as the remote SQL server do not allow bulk insert statement for security reason.Can anyone help us on how to insert data from local SQL Server 2000 to a remote SQL server.Thanks in advance. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-14 : 06:10:22
|
Why not simply backup the database, and restore it on your new site?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
moinul2007
Starting Member
2 Posts |
Posted - 2009-01-14 : 06:27:22
|
quote:
Originally posted by Peso
Why not simply backup the database, and restore it on your new site?
E 12°55'05.63"N 56°04'39.26"
Thanks for ur reply.Our remote SQL database do not provide backup or restore facility.I need to find a way to insert data from local SQL server to remote SQL server. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-14 : 08:48:19
|
| try using dts export import task |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-14 : 20:13:32
|
quote:
Originally posted by moinul2007
quote:
Originally posted by Peso
Why not simply backup the database, and restore it on your new site?
E 12°55'05.63"N 56°04'39.26"
Thanks for ur reply.Our remote SQL database do not provide backup or restore facility.I need to find a way to insert data from local SQL server to remote SQL server.
Then you need appropriate permission for it. |
|
|
|
|
|
|
insert data from local to remote SQL Server