Script a SQL Server 2005 Express DB

Hi,
I have a SQL Express DB that I've used for local development.
I now want to move this to an online sql server.
Is there a simple way to generate scripts or a batch file to re-create
the database online.
Online I only have access to creating stored procedures, and I don't
want to retype the entire DB.
Thanks in advance,
RangyHi
Take a look at BACKUP/RESTORE commnads or sp_detach_db and sp_attach_db
stored procedures
in the BOL
"Ranginald" <davidwank@.gmail.com> wrote in message
news:1145936902.665792.323020@.y43g2000cwc.googlegroups.com...
> Hi,
> I have a SQL Express DB that I've used for local development.
> I now want to move this to an online sql server.
> Is there a simple way to generate scripts or a batch file to re-create
> the database online.
> Online I only have access to creating stored procedures, and I don't
> want to retype the entire DB.
> Thanks in advance,
> Rangy
>|||You might want to look at a tool like SQL Compare from Red Gate. It
compares two databases and generates change scripts for you.
Hope this helps!
Chuck Heinzelman
MCSD, MCDBA
I support the Professional Association for SQL Server (www.sqlpass.org)
This posting is not an endoresment of any product.
Information is provided as-is, and carries no warranties - either express or
implied.
Please respond in newsgroups only.
"Ranginald" <davidwank@.gmail.com> wrote in message
news:1145936902.665792.323020@.y43g2000cwc.googlegroups.com...
> Hi,
> I have a SQL Express DB that I've used for local development.
> I now want to move this to an online sql server.
> Is there a simple way to generate scripts or a batch file to re-create
> the database online.
> Online I only have access to creating stored procedures, and I don't
> want to retype the entire DB.
> Thanks in advance,
> Rangy
>