March 1, 2006 at 6:40 am
The option to "copy objects and data between SQL Server databases" is now gone in SQL 2005 DTS. You only have the option to copy tables or write a script. Also, the checkboxes to include all dependent objects, security options, table options, etc are also gone and the "use quoted identifiers" box is now unchecked by default. I guess we just have to script objects now instead of using DTS to copy them between servers.
Has anyone heard whether these options will be re-added in sp1?
March 6, 2006 at 8:00 am
This was removed by the editor as SPAM
March 23, 2007 at 10:13 am
I was starting to wonder if I was the only one who had experienced this problem. Can anyone suggest a panacea?
March 26, 2007 at 6:07 am
I'm going to install sp2 on a test server this week and start checking it out. I was originally hoping that this issue would be resolved in one of the SPs but I don't have my hopes up because I haven't seen it listed in any of the service pack documentation. Will let you all know what I find...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply