How can I update local database data from an online database?

• enriquemallon

  Ten Centuries

  Points: 1239

  More actions

  September 22, 2014 at 3:47 am

  #296583

  I have an online database and a local database. How can I update the local database data (only data and not the structure) from the online DB in my application ?

  The idea is to have an update data button in our windows application to do that.

  Thank you.

• Elliswhite

  SSCommitted

  Points: 1783

  More actions

  September 23, 2014 at 1:20 am

  #1747304

  Can you tell the version of SQL Server?

  SSMS Expert

• enriquemallon

  Ten Centuries

  Points: 1239

  More actions

  September 23, 2014 at 1:33 am

  #1747311

  It was SQL Server 2008

• Elliswhite

  SSCommitted

  Points: 1783

  More actions

  September 23, 2014 at 1:36 am

  #1747313

  Try this OPENDATASOURCE and OPENQUERY to achieve this.

  SSMS Expert

• enriquemallon

  Ten Centuries

  Points: 1239

  More actions

  September 23, 2014 at 1:47 am

  #1747314

  Thanks for your suggestion