473,405 Members | 2,421 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

How to deploy a database on SQL Server Express 2005

Hello

Hopefully a really simple question. We have just finsihed a SQL 2005
database and vb.net app. We have been using SQL server 2005 Management
Studio during design.

We now want to copy the database across to a machine that has only got
SQL server 2005 Express. How do I do that ( I want the structure created
and tables created and data inserted on the target machine)

Thanks for your help.
KB

KB

*** Sent via Developersdex http://www.developersdex.com ***
Aug 10 '08 #1
4 3118
Backup and restore is the best option to copy the database.
Plamen Ratchev
http://www.SQLStudio.com
Aug 10 '08 #2
Thanks but on the target machine i dont have access to the management
gui to restore. Is there a different way to do the restore ( i.e command
line nor soemthing ) ?

Thanks
KB

*** Sent via Developersdex http://www.developersdex.com ***
Aug 10 '08 #3
You can use the SQLCMD utility to restore the database from the command
line:
http://msdn.microsoft.com/en-us/library/ms165702.aspx

The restore of a full database backup can be as simple as:

RESTORE DATABASE MyDatabase
FROM DISK = 'C:\MyDatabase.bak'
Plamen Ratchev
http://www.SQLStudio.com

Aug 10 '08 #4
Downloading "Database Publishing Wizard" might also be an option. As
indicated in its documentation, it is made available for remote
deployment scenarios.
Aug 11 '08 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Loane Sharp | last post by:
Hi there I had no luck in getting the following question answered in the SQL Server newsgroups. Please point me in the right direction. Background: I am using the "System.Data.SqlClient"...
1
by: Michael | last post by:
Hi, I've read Scott's article: http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx but when I try to create a new database file in App_Data with Visual Studio 2005, it shows error: ...
3
by: lbolognini | last post by:
Hi all, I'm new to SQLServer (Express edition) so I was wondering: if the web host supports SQLServer 2005 do I just need to move the .MDF file to my directory on the web host to be able to use...
0
by: Jonathan Wood | last post by:
I seem to be having errors creating and accessing an SQL database. Unfortunatley, I am brand new to SQL setup and administration issues so this really is not my area of expertise. I know I had...
2
by: Patrick F | last post by:
Hi, i have SQL Server 2005 and a database set that is called, myCompany the problem is that i cant connect from my page to it, here is from the web.config: ( i have got this connectionstring from...
5
by: Glen Buell | last post by:
Hi all, I have a major problem with my ASP.NET website and it's SQL Server 2005 Express database, and I'm wondering if anyone could help me out with it. This site is on a webhost...
5
by: Mahernoz | last post by:
Hi Everyone! I have a problem here. I have used the latest asp.net membership & profiles functionality in my site. I have 2 roles admin and user. I also have a user named admin. Now, my...
2
by: =?Utf-8?B?dHZpbg==?= | last post by:
Hi, I'm developing small windows application for my customer by using Microsoft Visual Basic 2005 Express Edition(free version) and i create sql database in it. my question is: 1. what...
1
by: Bobby Edward | last post by:
Here's the situation.... 1. Local dev environment is VS2005 and VS2008 / using SQL Express databases for data 2. Hosting company ONLY supports MS SQL Server 2005 databases Here are the...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.