Please help with DB upload?

[Energizeer]

Hi,
I have made a website which depends heavily on it's Database.
The site is online but I can't get my DB into the Host's DB.
My host has given me a DB. But there is nothing in this DB and I want to import my DB.mdf into it somehow.
I have MS SQL server management studio and have got onto my host and found the db he has given me. I right click on it but there is no option for import...?
I can't figure this out. Is there a program for uploading the Tables and Record and sub procedures into the Host's DB?

PLease help I have only have a day to get this right,
Thanks!

[dglienna]

I'd ask your ISP. I suspect that you'd just ftp the db up, and have them import it for you?

[hspc]

You should use SSIS (SQL Server Integration Services)
What edition of SQL Server do you use? Is it Express? It does not have SSIS AFAIK.

[Krzemo]

I have MS SQL server management studio and have got onto my host and found the db he has given me.

So U have online access to SQL Server database (in webside system) - wright?

I can't figure this out. Is there a program for uploading the Tables and Record and sub procedures into the Host's DB?

Since there is no way, for remote SQL Server, to access your file system (wright?) so there is no way that U could attach/detach or backup/restore without your ISP assistance.

But U could do it another ways.

1) Create SQL scripts (generate it) to script all objects of your local db and run them in remote db. Add remote server to your local linked server list. And write INSERT INTO ... SELECT scripts.

2) As in 1 but don't create linked server but create INSERT INTO ... VALUES ... (generate it from for example TOAD tool) and add this script to "crete objects" script, Than run it remotely

3) Use DTS to transfer data and objects

4) and maybe many more ....


HTH,
Krzemo

[spoulson]

You didn't mention what database version you're using.

If using SQL Server 2000, you can use the Data import/export wizard to copy all objects and data.

If using SQL Server 2005 (which it sounds like), you can also use the Management Studio to script the entire database contents into a file, which can be executed on the target database to create all objects and data.