CODEWITHSUNDEEP
sql-serverschemadatabase-restore
Bruno
Bruno

Reputation: 6449

How to restore a SQL Server database from a Schema Objects folder?

I received a Schema Objects folder like this:

Schema Objects 
|-- Tables 
  |-- Constraints
  |-- Indexes
  |-- Keys
  |-- Statistics
  |-- Triggers
  |-- ..and all the SQL scripts to create the tables

How do I restore this database to SQL Server, other than running script by script?

Upvotes: 0

Views: 103

Answers (1)

Coding Flow
Coding Flow

Reputation: 21881

IF you have visual studio pro or higher you should be able to add the files to a database project and then use VS deploy database option to create the schema in an empty database in a couple of mouse clicks

Upvotes: 1

Related Questions