how to convert sql from server enterprise to express

Question

0.00/5 (No votes)

See more:

i create a database with sql server enterprise edition. now i think when we want execute software in other systems must install 3.5 GB sql server enterprise in those systems. which is bad because cant create Independent setup for this software and this size is large

really is true? and it is how can convert this database to express? at the end what can i do?

thanks.

Posted 12-Jul-12 23:51pm

AliKiani

Add a Solution

Comments

Raje_ 13-Jul-12 6:18am

As far as i understood your question you want to run your software on a computer which has not installed SQL Server. If you want to do this then attach a software called SQL Native Client to your software while creating set up. it is very light weight software.

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)

Mehdi Gholam · Answer 1 · 2012-07-13T00:55:00

The only limit to SQL Express is the size of database you can have (4gb for 2005-8, 10gb for 2010 last time I checked), the database files are interchangeable with backup and restore so you don't need to do anything.

It is bad practice to install a database server for everyone with-in the same network, try installing 1 instance and connecting to that instance from other machines (change your connection string at runtime etc.).