Solved

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

Posted on 2008-10-13
7
147 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
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

910 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now