Click here to Skip to main content
11,575,109 members (58,210 online)
Rate this: bad
good
Please Sign up or sign in to vote.
Hi,
I want to publish my web application to local system and online, and than i want to
migrate data offline to online server. Please help me.......
Posted 30-Jan-13 1:55am
Comments
Zoltán Zörgő at 30-Jan-13 8:13am
   
It depends how you can connect to the remote server. What management surface do you have - if it is a web hosting service, consult the provider website and/or ask their hotline?
ryanb31 at 30-Jan-13 8:38am
   
It could be just as easy as backing up your local db and then restoring it to the online server.

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

You can use Linked server to communicate within two databases.
Refer:
MSDN: Create Linked Servers (SQL Server Database Engine)[^]
Setting up a Linked Server for a Remote SQL Server Instance[^]
Copy data from local table to remote database table[^]

BTW, do make sure you have backup of online database before replacement.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS


Advertise | Privacy | Mobile
Web03 | 2.8.150624.2 | Last Updated 30 Jan 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100