Click here to Skip to main content
12,889,963 members (43,712 online)
Rate this:
Please Sign up or sign in to vote.
See more: C# ASP.NET SQL-Server , +
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
Zoltán Zörgő 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 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
Please Sign up or sign in to vote.

Solution 1

You can use Linked server to communicate within two databases.
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.

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

    Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170424.1 | Last Updated 30 Jan 2013
Copyright © CodeProject, 1999-2017
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