• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 157
  • Last Modified:

Can an SQL Server DB be copied from my laptop hard drive to my web hosting service?

I realize this is a strange and ignorant quesiton but...

I want to install SQL Server 2005 Express on my laptop and build a database, but then I want to move the database to my web hosting service when it's complete. I know my hosting serivce supports MS Server 2005, but I just don't know if I can or how I would copy the database from the laptop to the server. Can this be done from SQL Server Management Studio (if that's what it's called)?

I appreciate your time and any insight you can give me.

Thanks,
JA67
0
JA67
Asked:
JA67
3 Solutions
 
chapmandewCommented:
You can easily backup the database and move it to where you need it and restore it there.  As for if you can get it to your web host or how you would do it...it really depends.  So long as they support SQL, it CAN be done, but it might take a CS call to figure out what you need to do to get it accomplished.
0
 
brad2575Commented:
You can create a backup of the DB file in the studio (just right click - Tasks -  and click backup)

Then your web hosting will need to be able to "RESTORE" the database from the backup copy you created.
0
 
razorwoodsCommented:
MSSql 2005 doesn't have any built-in way to do,  however there is a utility you can use if you really have to.  It's called BCP.

http://msdn.microsoft.com/en-us/library/ms162802.aspx

0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
razorwoodsCommented:
I should clarify ..... MySQL 2005 Express doesn't have this capability built in.
0
 
chapmandewCommented:
>>MSSql 2005 doesn't have any built-in way to do,
sure it does.
0
 
chapmandewCommented:
>>2005 Express doesn't have this capability built in.

Sure it does...you can use TSQL to do it:

backup database dbname
to disk = 'c:\path\backup.bak'
0
 
JA67Author Commented:
Thank you all very much! That was very quick!
JA67
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now