Switch local database to service-based database or VS

Question

0.00/5 (No votes)

See more:

, +

Hello Guys,

I need your advise/suggestion for following situation;
Suppose i have a Windows application (VS 2013) within that I used Local database (.mdf).

Questions :

1. Can we use Service database(MS SQL server) for development and deploy same like local database in side folder?
i.e. Means after installation of windows application. database should work locally (As client machine only have framework in offline mode)

2. Can we restore local database .mdf to MS SQL server studio. Need this while development

Need :

Work on MS SQL server studio while development (b/c its easy) and at the time of deployment deploy inside windows application folder (like Local Database).

Hope you guys understand my concern.

Thanks,

Posted 24-Sep-15 0:21am

Padam Agrawal

Add a Solution

Comments

BulletVictim 25-Sep-15 5:50am

Yes it is possible to do so. Firstly the connection strings would obviously need to be changed to look at the different Databases(easier way might be to code bought already but use the if(Debugger.IsAttatched) way to keep working on MS SQL DB while debugging.(using System.Diagnostics). Then Ensure that after publish the Database is also copied to the output path, then using Application.Startuppath to navigate the location of the local DB. Deploying the Local database usually requires you to mark it as a needed file for the application to install. (Scratch around a bit, I cant fully remember as to how to do this exactly. Google could help on that.)

Padam Agrawal 25-Sep-15 7:33am

Thanks for suggestion. Would be better for me if get some reference.

1 solution

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)

Padam Agrawal · Answer 1 · 2015-09-25T08:32:00

Solution 1

Yes- We can directly attach MDF file with MS SQL server using Attach database option from desire location.

Its working.. :)

Posted 25-Sep-15 8:32am

Padam Agrawal