shaik47
shaik47

Reputation: 463

Create database and add data during application installation

I have developed a windows form application. I have also created a database on sql server and added data to this database.

Now i want to install this application at clients place. I want to know the ways to move my created database on client's location. How can i do this during application installation? If i have to include database scripts in installation file and run it.how can i do it? If its a long process please specify links which helps me in accomplishing this task.

Thankyou very much.

Upvotes: 0

Views: 106

Answers (1)

Mitch Wheat
Mitch Wheat

Reputation: 300719

Look at the GDR R2 database project (part of Visual Studio).

You can use this to reverese engineer your existing database into scripts within a Database project, and place under source code control. You can synchronise existing and deploy fresh databases from this project.

You can also use commercial tools such as those sold by RedGate.

Upvotes: 1

Related Questions