copy database from web host to local?

Hi,
I also posted this question in sqlserver.DTS because I'm not sure where it
should go.
I'm trying to restore my local db from the one in my web host. I asked the
web host for help, and the only help they can offer is that: "Use SQL Server
Integrated Services (SSIS), which is integrated with the commercial version
of SQL Server Management Studio Express." I don't know what that means.
I also tried the DTSWizard.exe, but it only copies the data. It leaves out
my relationships, the keys, the SPs, etc...
What's the best way to copy a database from one sever to the other so that
everything is included?
Both are sql server 2005, and I want to copy from my web host to my local
server.
Thanks.
VMI (VMI@.discussions.microsoft.com) writes:
> I also posted this question in sqlserver.DTS because I'm not sure where it
> should go.
> I'm trying to restore my local db from the one in my web host. I asked
> the web host for help, and the only help they can offer is that: "Use
> SQL Server Integrated Services (SSIS), which is integrated with the
> commercial version of SQL Server Management Studio Express." I don't
> know what that means.
Well, Integration Services is not included in Express as far as I know.
Probably what they have in mind is the Copy Database Wizard, but you
would need to cough up around 50 USD for Developer Edition to get it.
Problem, though is that you would have to use the SMO method, which is
not very reliable.

> I also tried the DTSWizard.exe, but it only copies the data. It leaves out
> my relationships, the keys, the SPs, etc...
You can use the scripting capabilities in SSMS Express to script the
database, and then copy the data separately.
What you really should have done is do have all your database definition
under version control.

> What's the best way to copy a database from one sever to the other so that
> everything is included?
BACKUP/RESTORE, but that option is not likely to be available in
your situation.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx