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.In the June CTP you can use the Transfer Objects Task. It has an option for transferring data that you may set to false.|||BTW, There are some issues with this task in the June CTP that have recently been fixed and will not be available until the next CTP. This solution will probably not work for you until you can get the version with the fixes.
|||Hi Kirk,
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.|||
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
No comments:
Post a Comment