Member Avatar for mhbd

Hi All,

We have a local MS SQL 2000 database which is daily updated by the users. We have a remote MS SQL database under windows based hosting. Now i need to update all existing data from local MS SQL to remote MS SQL database. I also need to find a suitable solution to update remote MS SQL from local MS SQL daily.

I tried bulk insert SQL cmd to upload all existing data. But bulk insert is blocked and cannot be activated.

I tried backup / restore, but remote MS SQL database do not provide backup / restore facilities.

Data size is small around 10,000 records. Each record is around 50kB.

Can anyone help me to solve this problem

Thanks in advance!

  • 2 Contributors
  • 1 Reply
  • 66 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by Ramy Mahrous
Member Avatar for Ramy Mahrous

You can use replication or use SSIS to move the data (formerly know DTS)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.