use sql server .mdf file

Question

I am developing a software with vb.net 2010 and sql server 2008 R2. While developing with my laptop where sql server is running every thing is ok, but when I want to deliver the project to the customer I must install sql server R2 to customer machine. How to get my database .mdf format to use it with my project. Thankyou

Edper · Accepted Answer · 2013-11-21 06:02:19Z

1

You need to detach the mdf file from your computer and then copy that file to your storage device of your choice say a USB. Afterwards if there is already an installed SQL server in your client you could copy the mdf file that you detach and then attach that mdf file this time.

To Detach:

Right Click on the Database that you want to Detach then Task --> Detach

enter image description here

To Attach:

Right Click on the word Databases then Attach

enter image description here

Don't forget of course to Attach again in your own computer the Database that you detached earlier.

edited Nov 21, 2013 at 6:02

answered Nov 21, 2013 at 5:47

Edper

9,3621 gold badge32 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Hilal Al-Rajhi Over a year ago

This is fine, but will this deletes the database from the my computer? You said I will need to attach again the database!

Edper Over a year ago

@alrajhi20 No it will not delete your file. You could not copy an mdf file unless it is detach and you could not use it again unless it is attached back.

Hilal Al-Rajhi Over a year ago

Can I use this .mdf database for my softwares? Instead of attaching them again in my sql server? I mean as a local database than server database?

Christian Specht · Accepted Answer · 2013-11-22 22:09:35Z

Just make a backup of your database and restore it on the client's machine.

You can do this either with Visual Studio:

...or with T-SQL:

Detaching and attaching the database (as described in the other answer) is possible too, but the recommended way is making a backup.
Plus, if you are running at least SQL Server 2008 R2 Standard Edition on your laptop, you can use SQL Server's built-in backup compression, which will significantly reduce the size of the backup file (compared to the regular database size).

Collectives™ on Stack Overflow

use sql server .mdf file

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related