0

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.

Community
  • 1
  • 1
  • 1
    Run the scripts? What have you tried? Are you getting errors? – David Starkey May 31 '13 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. –  May 31 '13 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 –  May 31 '13 at 16:08
  • No errors is good, but did it work? What did happen? – David Starkey May 31 '13 at 16:09

1 Answers1

1

You can use Microsoft SQL Server Management Studio Express!

http://www.microsoft.com/it-it/download/details.aspx?id=7593

tezzo
  • 10,858
  • 1
  • 25
  • 48