Hi

Our web host is gradually migrating to SQL Server 2005 and obviously this means we need to be able to transfer our development databases to the live server still.

It would seem the DTS wizard I loved has been replaced by SSIS packages which are designed using Business Intelligence Development Studio.

I want to be able to transfer all database objects (apart from logins) from the development to the remote server. The only way I can see to do this is using a Transfer SQL Server objects task - however this doesn't seem to work. I can't use copy database as the host only gives limited access.

Any one got any ideas how to transfer all of my database (tables, stored procedures, user defined functions, trigger, and all relationships).

Cheers

Dave