I tried to copy all objects from one SQL Server DB to another. The target DB
was new with nothing but the default sys tables. When I ran the DTS task it
looks like it copied all the tables and then failed with the error shown
below. None of the views or SPs got copied? Any ideas on what causes this?

Wayne

================================
Need to run the object to perform this operation

Code execution exception: EXCEPTION_ACCESS_VIOLATION [SQL-DMO]The Bulk Copy
execution failed.

It turns out that all the table structures appear to have been copied but
only a few of the tables have the data?

Wayne

"Wayne Wengert" <wayneDONTWANTSPAM (AT) wengert (DOT) com> wrote

Wayne...

Make sure that acount for the target DB has the right permissions..
If table structure it was written, then use the option
'Copy Objects'>Copy Data>Append Data

This actions put rows inside tables...



"Wayne Wengert" wrote:

I Forget...

If you cant copy views, sp, then take the script and run from Query Analyzer..

Other things, DTS Objects are not copied, you need other ways to put them on
the target server...
Here you have one document from Microsoft abput copy of Databases

http://support.microsoft.com/kb/314546/en-us#3

Salutes..



"Wayne Wengert" wrote:

The error is non-descriptive so one of the frequent problems with this
task is transferring local users to a remote box.

Personally though If I want to move a DB lock, stock and barrel I will
use a backup and restore


Allan



"Wayne Wengert" <wayneDONTWANTSPAM (AT) wengert (DOT) com> wrote

Good advice but since we don't own the server it is not an option (we just
have an account with the one DB)

Wayne

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Then why not script it out, apply your scripts then create Datapump
tasks for the data.

Allan

"Wayne Wengert" <wayneDONTWANTSPAM (AT) wengert (DOT) com> wrote

Allan;

Sounds like a good alternative. Where can I get information on creating
datapump tasks?

Wayne

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Have a look here

Building a Package in the DTS Designer
(http://www.sqldts.com/default.aspx?278)

"Wayne Wengert" <wayneDONTWANTSPAM (AT) wengert (DOT) com> wrote