Hi,
Does anyone know, with either the Apr or Jun CTP, how to copy an entire database without the data I know to use the SSIS wizard to copy tables with data, but there seem to be no option to not copy the data.
Thanks.
Copying Database without data
Hot Topic
- SQLServerAgent won't start
- Error message "Interface not registered"
- Full-text index becomes unavailable
- Isql and network path error? (What happens really)
- Trouble with MS SQL 2000 Reporting Services
- Queries returning Multiple instances of the same record
- Cannot open backup device 'F:\foldername'. Operating system error 5(Access is denied.).
- SQL Server 2005 Service Pack 1 - Timeframe?
- Help with SSIS error
- How to turn off logging
SQL Server
- Constants to Sets
- How to change name of filter in Report Builder
- Maintanance Plan
- does "with (nolock)" absolutely guarantee no locks are taken?
- Not able to connect to SQL Server 2005 Express Server
- DTS connection
- The Query Could not be processed. The data provider didn't supply any other error information (SSAS 2005, SharePoint, OWC 11)
- CTP Expiration Dates
- Deleting legacy maintenance plans - 2005
- IIf problem
Copying Database without data
Lovelu
Kaiser
you can
1. left click source database ->Script database ->create to
1.1. change database and filenames on the script created
1.2 execute script to create new database
2. left click source database -> tasks -> generate scripts
2.1 add at the to the following lines
use newdatabasename
go
2.2. run the script
you can save the scripts and use them at SSIS for automation
Mike Droney
Caroline_C#
Thanks for the update. I was actually hoping for a checkbox option inside the SSIS Import and Export wizard. :) I'll wait till it is fixed then.