title: How to import script (.sql extension) database into SQL Server 2012
body: <p>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:</p>
  
  <ol>
  <li>Right click on the database under Tasks;</li>
  <li>Click generate scripts and follow the wizard;</li>
  <li>Advance option: Types of data to script = Schema and data</li>
  <li>Finished</li>
  </ol>
  
  <p>However, when I open the file and transfer it in an empty database (execute the <code>script.sql</code>) 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.</p>
  
  <p>Here is the screenshot.</p>
  
  <p><img src="https://i.stack.imgur.com/D0olr.png" alt="enter image description here"> </p>
  
  <p>And when I try to execute the script.sql file on the new Copy of database (db_Copy), There is an error message below. ''</p>
  
  <p><img src="https://i.stack.imgur.com/6L72O.png" alt="enter image description here"></p>
  
  <p>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.</p>
  
  <p>Please help me, All i want to do is to my database to another database using the generated scripts.</p>
  
  <p>Thanks in advance.</p>
  
  <p>EDIT: What is the proper way to import the generated scripts on the empty database?</p>