How to import script (.sql extension) database into SQL Server 2012

Question

I have a problem in importing a database script in SQL Server 2012 Management Studio however, I successfully exported the schema and data. In exporting the database, I have done the steps:

Right click on the database under Tasks;
Click generate scripts and follow the wizard;
Advance option: Types of data to script = Schema and data
Finished

However, when I open the file and transfer it in an empty database (execute the script.sql) using SQL Server Management Studio, I can't import it. On SQL Server 2008 I can easily do that thing but on SQL Server 2012, I think there is something wrong on it.

Here is the screenshot.

enter image description here

And when I try to execute the script.sql file on the new Copy of database (db_Copy), There is an error message below. ''

enter image description here

Please help me on this issue, Have I done something wrong in exporting my data (Generate script)? Or It can be on SQL Server I'm using? I am using SQL Server 2012 Express.

Please help me, All i want to do is to my database to another database using the generated scripts.

Thanks in advance.

EDIT: What is the proper way to import the generated scripts on the empty database?

What about the error isn't clear to you? That database db_Dasureco you're trying to create in the SQL script already exists on this SQL Server instance. Either don't try to create it again, or use a different database name ...... — marc_s
– marc_s, Commented Feb 4, 2014 at 6:19
Yes. I tried to change the database name, ex. CREATE DATABASE [db_NewCopyDatabase] , but it didn't execute. I executed the script then it takes 10 mins now of running the script. Is it normal? — user2656044
– user2656044, Commented Feb 4, 2014 at 6:33

Francesco Mantovani · Accepted Answer · 2018-07-02 01:12:07Z

2

Create an empty database or if you have one already target that one.

Open CMD with elevated privilege and run:

sqlcmd -S SERVERNAME -d MYDATABASE -U USERNAME -P PASSWORD -i C:\path\mysqlfile.sql -o C:\path\results.txt

basically:

-S: is your servername or localhost
-d: is the database you are targeting
-U: is the username
-P: is the password
-i: is the path to your .sql file
-o: is where the logs file will be saved so if you had problem during the importation you can debug them

edited Jul 2, 2018 at 1:12

answered Jul 2, 2018 at 1:05

Francesco Mantovani

12.8k20 gold badges104 silver badges178 bronze badges

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

Comments

Oscar Duran · Accepted Answer · 2015-11-18 15:26:11Z

0

Replace [db_Dasureco] for [db_NewCopyDatabase] not only in CREATE DATABASE, but everywhere you see [db_Dasureco].

answered Nov 18, 2015 at 15:26

Oscar Duran

1172 silver badges15 bronze badges

Collectives™ on Stack Overflow

How to import script (.sql extension) database into SQL Server 2012

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related