How Do I Deploy A C# Application Including Sql Express

Question

0.00/5 (No votes)

See more:

Hello There,

I have completed my c# winform project and i want to deploy it on a network. Before i could install the application, i want to install sql express, before that i want to check whether any other sql instance is available on the network. If any other instance is available on the network then i just want to copy my database to the available instance, if no sql server is found on the network then the deployment should install sql express and copy my database to it.

I need help and suggestion on the above, would highly appreciate in advance......

thanks & regards,

Antony

Posted 27-May-15 0:53am

Member 11261811

Updated 27-May-15 1:03am

King Fisher

v2

Add a Solution

Comments

Andy Lanng 27-May-15 7:11am

Wow. You don't want much, do you :P

I suggest you break down your issue into a few questions. The first, I imagine, is "How do I detect SQL Servers available in the Network".

For that I can recommend this article: Finding SQL Servers on the Network
Or SQLPing. You can find the source here SQLPing

Member 11261811 28-May-15 1:45am

Thanks for the link. Please find below my questions :
1. How do I check any sql server instance running on the network during my C# winform application installation.
2. How do I install or create my database and tables during my C# winform application installation.

Thanks & Regards,

Antony

Andy Lanng 28-May-15 3:56am

You need a custom action in your setup project. Take a look at this:
Walkthrough: Creating a Custom Action

John C Rayan 27-May-15 8:36am

If you are in corporate environment , talk to your DBA find out your suitable SQL Server. Then DBA will sort out helping you copying your SQL database. But if your database created in higher version than one in your network you cannot copy it.

Member 11261811 28-May-15 1:46am

Hi John,
I need to handle the copying of database and checking the sql server instance thru my deployment/setup module of my C# winform application.

John C Rayan 28-May-15 4:23am

You need to learn SMO

https://msdn.microsoft.com/en-us/library/ms162557.aspx

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)