You can do these steps:
- First generate a .sql file consisting of the only the schema of the source database (Right click on database => Generate Scripts => follow the wizard).
- In .sql file, replace the database name with a new database name.
- Have the data in the database. (Rightclick on source database, import data => datasource and then select the tables for source: )
It also depends whether its SQL Server express edition. Some of the capabilities arent there in express edition.
Gauravsa posted this
Have an answer?