How to recreate database from scripts in SQL Server 2008?

Question

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.

Run the scripts? What have you tried? Are you getting errors? — David Starkey
– David Starkey, Commented May 31, 2013 at 14:22
it has 40 sql script files, I use sqlcmd to run the first script and has some errors, anyway I will try to use sqlcmd -e to see what really happen. — user1482015
– user1482015, Commented May 31, 2013 at 15:39
I see, the sql files is utf8 file and it contain unicode data, I force it to use utf-8 codepage by -f 65001 ---> SQLCMD -S mywindows\sqlexpress -i abcdb001.sql -f 65001 , no errors — user1482015
– user1482015, Commented May 31, 2013 at 16:08

tezzo · Accepted Answer · 2013-05-31 14:30:33Z

1

You can use Microsoft SQL Server Management Studio Express!

answered May 31, 2013 at 14:30

tezzo

11.2k2 gold badges27 silver badges50 bronze badges

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

1 Answer 1