Solved

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

Posted on 2008-10-13
7
149 Views
Last Modified: 2010-03-19
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
Comment
Question by:JA67
7 Comments
 
LVL 60

Expert Comment

by:chapmandew
ID: 22705460
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
 
LVL 16

Accepted Solution

by:
brad2575 earned 200 total points
ID: 22705466
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
 
LVL 3

Assisted Solution

by:razorwoods
razorwoods earned 150 total points
ID: 22705480
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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 3

Expert Comment

by:razorwoods
ID: 22705488
I should clarify ..... MySQL 2005 Express doesn't have this capability built in.
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22705490
>>MSSql 2005 doesn't have any built-in way to do,
sure it does.
0
 
LVL 60

Assisted Solution

by:chapmandew
chapmandew earned 150 total points
ID: 22705503
>>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
 

Author Comment

by:JA67
ID: 22705571
Thank you all very much! That was very quick!
JA67
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question