Reputation:
Refer to Exporting data In SQL Server as INSERT INTO
Recently, my client gave me 40 .sql
files, I believe he generated them by above method.
I look at the first .sql
file, it contains create database
, create table
, and many insert
statements.
How can I use these .sql
files to recreate the whole database? We are using SQL Server 2008.
Upvotes: 0
Views: 438
Reputation: 11115
You can use Microsoft SQL Server Management Studio Express!
http://www.microsoft.com/it-it/download/details.aspx?id=7593
Upvotes: 1