SQL 2005 CTP - Export Data & Generate Scripts
Has anyone else tried SQL 2005 CTP...the Import/Export Data Wizard DOESN'T have an option for 'Copy objects and data between SQL Server databases'. Microsoft suggests to use the 'Copy Database Wizard' to copy over objects now...fair enough EXCEPT the copy database wizard copies the whole database...so what if you only want to bring over a few tables?
I have also noticed that the 'Generate Script' function is lacking as well. In previous versions you could pick tables, indexes, view, triggers etc... the new version gives most of that with one big flaw. No matter what you choose, you can not deselect to 'Create Tables'..so if you just wanted to script the indexes for a database (because the export wizard didn't bring over the indexes...cough...cough) you would have to edit the script and remove the parts to CREATE tables.
Am I missing something, or do you think the 'real' version of SQL 2005 will address this missing functionality.
Thank you,
[973 byte] By [
JimKing] at [2008-2-4]
Hello -
You're right - the copy database wizard does just that, copies the entire database. You can use a more general copy wizard, however, and just mark the items you're looking for. I'm not sure where you're seeing that you can't copy individual items - are you using SQL Server Express?
On the other issue, you just need to change the options in the tool bar to set the scripting options for getting permissions, all objects, and so on.
