I've got 30 minutes to transfer a database from local testing server to live
.....

I'm using the DTS wizard, and unlike the 2000 version, it seems I'm unable
to specify that I'd like to drop destination objects and recreate them on
live server, but this option is unavailable. Also, why can I not globally
state this rather than having to specify it for each table?

Would a BACKUP / RESTORE be an alternative appraoch..

--
HTH. Ryan


"Calvin Willman" <someone (AT) anon (DOT) com> wrote

Hi Ryan,

Unfortunatly, I don't think my Hoster gives access to do that. I think the
database has now corrupted completly, it's either that or I need to
reinstall management studio/VS as I can't even connect to the database now
to see if the transfer worked as is... so it looks like I'm back to drawing
board on this anyway.

Thanks for your input though....

"Ryan" <Ryan_Waight (AT) nospam (DOT) hotmail.com> wrote