0

I want to deploy a project which is coded in C# with SQL Server as the database server.

I have to deploy the project where there is no SQL Server installed.

Anybody have any idea about how this can be done?

Thanks.

Improve this question
1
  • 2
    Why create a database schema if there is no database is installed? Or do you need to install the database server, and want to know how to deploy the schema from development to production? Or are you looking for suggestions for a embedded database server? Commented Apr 9, 2011 at 7:36

1 Answer 1

Reset to default
1

A full SQL Server install is probably not something you should even try to deploy - licensing aside, the configuration of a SQL server is environment dependent. It would be better to list sql server as a pre-requisite in documentation only, and get it installed manually.

If your database is smaller, though, a SQL server express install might be reasonable to embed in an installer (if you use a named instance); IIRC the larger version of the installer allows you to create a custom installer for an application, ideal for deployment scenarios.

Even better; if you can fit into SQL server compact, then that is an embedded server; there is no install as such - just ship the runtime with the application.

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

1 Comment

Thanks @Marc I got that it will good to use SQL Server Compact Well i Need procedure to deploy my project with database Will you please tell me step involving in same

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.