How to deploy a database on SQL Server Express 2005

[Kerrin Banner]

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

[Plamen Ratchev]

Re: How to deploy a database on SQL Server Express 2005

Backup and restore is the best option to copy the database.


Plamen Ratchev

http://www.SQLStudio.com

[Kerrin Banner]

Re: How to deploy a database on SQL Server Express 2005

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

[Plamen Ratchev]

Re: How to deploy a database on SQL Server Express 2005

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

[nidaar]

Re: How to deploy a database on SQL Server Express 2005

Downloading "Database Publishing Wizard" might also be an option. As
indicated in its documentation, it is made available for remote
deployment scenarios.