Creating or adapting a SQL Server database from a scripts folder

Question

I currently have a source controlled directory which represents a DB (i.e. it has create scripts for table, stored procedures, etc). This is currently synchronized with an actual DB using RedGate SQL Compare software. Is it possible to (possibly using a standard MS database project) to script these tables to create a new (or adapt an old) database without using the same RedGate software?

I've tried creating a new MS database project, but it seems to want to run from an existing DB, or have files added one at a time.

Keith · Accepted Answer · 2013-10-04 14:06:46Z

1

Consider creating a new database project, then use the Import Database feature to populate the project with the objects from your database server.

answered Oct 4, 2013 at 14:06

Keith

21.4k11 gold badges90 silver badges130 bronze badges

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

3 Comments

Paul Michaels Over a year ago

I did consider that, but I wanted to be able to do this without creating a database first.

Keith Over a year ago

From your post it sounds like you already have a database created.

Peter Schott Over a year ago

I think Keith is on the right track. Create the database locally from your scripts and import from there into a project or import directly from your already existing database. If you can access the existing database, you should be able to easily create the project from that. I would also consider migrating to SSDT instead of VS DB Projects if you have the option.

Collectives™ on Stack Overflow

Creating or adapting a SQL Server database from a scripts folder

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related