how can i save my .net database to be used on another computer

Question

0.00/5 (No votes)

See more:

hi, i am changing computers and i want to move my .net projects to this computer, i can just copy the files from the project folder but the problem i am facing is how to save and transport the databases to this new computer. in short, i want to be able to save or export my databases for all my current projects so that i can sort of re-deploy them on the the new computer. I am using ms sql server 2005, the one that comes with microsoft visual studio 2008

Posted 26-Dec-10 2:34am

Member 7250221

Updated 26-Dec-10 2:47am

v3

Add a Solution

Comments

Manfred Rudolf Bihy 26-Dec-10 8:36am

What DBMS are you talking about? SQL Server, MS Access, DB4Objects etc. ? Please specify and while you're at it also note the version for each DBMS you are using. Cheers!

#realJSOP 26-Dec-10 8:37am

What kind of database? Access? SQL? MySql? SqlExpress? Oracle? Something else?

[no name] 26-Dec-10 8:47am

i am using ms sql server 2005, dbms that comes with vs 2008

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)

#realJSOP · Accepted Answer · 2010-12-26T04:10:00

There are a few things you can do:

0) Convert your database to be completely xml-based. You can then free yourself from SQL server, and your application becomes the control for the data. This is probably not what you - personally - want to do because it involves writing more code, which then has to be tested. Just know that the option is there.

1) Deploy SQL Server Express with your application. This is fraught with danger because you then have to rely on the user to install it correctly, and we all know that end users are just slightly above a fog bank in the intelligence scale.

2) Host all the data yourself on your own server, and provide a web service for retrieving/updating the data that your application(s) can connect to. This also has a downside because now you have to make sure the server is ALWAYS available, make backups, provide redundancy, and all that other data provider mess.

Those are your options as I see them.

Al-Farooque Shubho · Accepted Answer · 2010-12-26T04:13:00

I assume your new PC has SQL Server installed. So, what you can do is as follows:

1. Take backup of SQL Server database(s) from the source PC.

2. Restore the backups into the destination PC's SQL Server database.

3. Update the ConnectionString property value of your .NET projects so that, the ConnectionString points to the new Database server, along with correct database names and credentials.

See http://www.sqlteam.com/article/backup-and-restore-in-sql-server-full-backups[^] to learn how to do Backup and Restore of SQL Server databases.

how can i save my .net database to be used on another computer

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0