SQL Server 2012 copy database without data

  1. Right click your database in your server, and select Tasks > Generate Scripts.
  2. At Introduction step, click Next.
  3. At Choose Objects, you can either select either the entire database (including functions, and etc) or specify what objects you want to generate. In your case, you should select Script entire databases and all database objects then hit Next.
  4. Choose your file name and destination then click next
  5. Review and then click next
  6. Done!

You will see a .sql file generated in your specified folder. You can open that file in other servers and hit execute, it will then generate a exact same database.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)