How to copy server database to the local host server

Question

0.00/5 (No votes)

See more:

I want to create a website. That contain database in server side. When i acess the website at local host, that time i want the database at server side to copy into local host. After i am updated the database i want to replace or update the database at server. I am new to Asp.net, so if some knows these help me.

Posted 31-Jul-11 21:36pm

ssyuvaraja

Add a Solution

Comments

Syed Salman Raza Zaidi 1-Aug-11 3:41am

do you want a copy of Server's database on local host? right?

ssyuvaraja 1-Aug-11 4:38am

yes.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Answer 1 · 2011-07-31T21:44:00

That is a very bad idea - why do you want to do that?

Think about it: Databases and websites are multi-user capable. If you do what you are suggesting, then each user who tries to log in to your system will get a local copy of the database. They will then modify it, and write it back to the server. The one that takes longest to make the changes will be the one who last writes the database - everybody elses' changes are potentially lost.

What are you trying to achieve, because I can't help thinking this is very much the wrong way to go...

Monjurul Habib · Answer 2 · 2011-07-31T21:45:00

Solution 2

SQL Server Schema Comparison Tool in Visual Studio 2010[^]
SQL Server Data Comparison Tool in Visual Studio 2010[^]

http://msdn.microsoft.com/en-us/library/aa833435.aspx[^]
http://msdn.microsoft.com/en-us/library/dd193261.aspx[^]

Posted 31-Jul-11 21:45pm

Monjurul Habib