?
Solved

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

Posted on 2008-10-13
7
Medium Priority
?
153 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 800 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 600 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
10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

 
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 600 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

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

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

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

752 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