Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

Copy database layout, tables, ... but no data

Discussion in 'General' started by kfmssql, May 30, 2013.

  1. kfmssql

    kfmssql New Member

    SQL 2005: Hi, I'm wanting to copy a database (layout, tables, views, sp, ...) all except the data. In management Studio I'm using the "Script Database as/CREAT To/File". It's creating the database but it's not creating the tables, views, or the SP.

    What am I doing wrong, should I be using another method to copy database without the data?

    Thanks,
    kfmssql
  2. kfmssql

    kfmssql New Member

Share This Page

Sponsored link: