Posted by Mark Olbert on 12/02/06 00:17

I'm looking for help in getting the Transfer Sql Server Objects task to work. The goal is to transfer the tables, views, sprocs,
udfs from a SqlServer 2000 database to a Sql Server 2005 database.

When I set the task up and run it, it fails complaining about an invalid foreign key relation. The relation in question is valid,
and used in the current production environment under SS2000, so I think the real problem is something else. I've seen reports that
this kind of error occurs when the Transfer task encounters a foreign key involving a table that hasn't been transferred yet.

As an aside, this kind of transfer worked flawlessly under Enterprise Manager when I used the DTS Wizard to move the objects between
two instances of SqlServer2000. Unfortunately, Enterprise Manager doesn't appear to work with SqlServer2005.

Any help and/or pointers would be greatly appreciated (including other strategies on how to affect the transfer -- I tried using the
Transfer Database task, too, but it failed when it supposedly couldn't find the path on the target server -- I say supposedly
because it was able to find the path in order to delete the pre-existing files on the target server)!

- Mark

[Back to original message]