Web Development

General discussion


Deploying MSDE with Database

By nitesh.shah ·
Hi ,

I need to deploy my MSDE server with a fix database into it using .net can any one provide me sample code for the same ..

Thanks in advance

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by BFilmFan In reply to Deploying MSDE with Datab ...

What exactly are you calling a fix database?

MSDE uses a SQL database.

Which .NET programming language are you trying to use?

Collapse -

by Tony Hopkinson In reply to Deploying MSDE with Datab ...

I presume you mean fixed database.
The simple way is simply to create a script that creates the DB, tables, users etc and populates it.
Then just run it from the command line. Look up usql.exe, you get that bundled with MSDE.
If you've got access to SQL Enterprise you can get it to generate the script file for you.
Distibute the script file itself then just pass it as a parameter to USQL.
If you want to be neat and tidy, use the CreateProcess API and WaitforSinleObject. You'll be able to find plenty of examples of each step through google.

In fact I'd be surprised if google wouldn't provide the full example you describe

Related Discussions

Related Forums