CODEWITHSUNDEEP
sql-serverdatabaseversion-controldatabase-project
Paul Michaels
Paul Michaels

Reputation: 16685

Creating or adapting a SQL Server database from a scripts folder

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.

Upvotes: 0

Views: 151

Answers (1)

Keith
Keith

Reputation: 21224

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

Upvotes: 1

Related Questions