Solved

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

Posted on 2008-10-13
7
151 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 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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
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

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

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

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
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…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

729 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