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 (V**@discussions.microsoft.com) writes:
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.

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.

BACKUP/RESTORE, but that option is not likely to be available in
your situation.

Square Brackets
Database copy
one-to-one relationships in a database diagram
Last Modified Date of table, queries, views, sprocs
SQLDMO with VB6