CODEWITHSUNDEEP
visual-studio-2010sql-server-2008installationsetup-project
cnd
cnd

Reputation: 33714

Making script to create database skeleton for SQL Server 2008

I'm making Visual Studio setup for my project.

I want it automatically create empty database inside some SQL Server 2008 (Express)

  1. Is there some tool / way to automatic generate such script of my database (sadly my database structure isn't stable yet)
  2. How can I add it to installation process ? I know that I can run programs and scripts during installation but how can I specify SQL Server for my script ?

thank you.

Upvotes: 1

Views: 1707

Answers (1)

Mitch Wheat
Mitch Wheat

Reputation: 300489

In SSMS, Right-Click on database -> Tasks... -> Generate Scripts....

Suggest you also look at using the Database GDR R2 projects (if using VS 2008) or the built-in database project if using VS 2010.

Upvotes: 3

Related Questions