Copy database without the data on a Cd?

Hi all,
We have a website with a database connected to a SQL server. I need
to copy that database without the data onto a CD so I can place the
program on another server?
Any help would be greatly appreciated.You can generate create table/procedure/view scripts from within Enterprise
Manager / Mangement Studio. Or you can use a 3rd party tool like SQL
Compare from www.red-gate.com ...
<mchin247@.gmail.com> wrote in message
news:1184684718.199501.113020@.e9g2000prf.googlegroups.com...
> Hi all,
> We have a website with a database connected to a SQL server. I need
> to copy that database without the data onto a CD so I can place the
> program on another server?
> Any help would be greatly appreciated.
>|||You can make a backup and restore the database on another server or under a
different name. Then run the script I posted in my blog to delete all data
in the database -
http://www.sqljunkies.com/WebLog/ro.../08/18620.aspx. After
that you'll have a database with no data, you can back it up and distribute.
As Aaron mentionned, you could also script out all database objects but you
may have to tweak those scripts manually and have them execute in the right
order because script generation tools often don't handle dependencies. So
when you run the script, it might fail if a referenced object hasn't been
created yet.
Roman
Roman Rehak
http://sqlblog.com/blogs/roman_rehak
<mchin247@.gmail.com> wrote in message
news:1184684718.199501.113020@.e9g2000prf.googlegroups.com...
> Hi all,
> We have a website with a database connected to a SQL server. I need
> to copy that database without the data onto a CD so I can place the
> program on another server?
> Any help would be greatly appreciated.
>|||ApexSQL Diff should help here.
TheSQLGuru
President
Indicium Resources, Inc.
<mchin247@.gmail.com> wrote in message
news:1184684718.199501.113020@.e9g2000prf.googlegroups.com...
> Hi all,
> We have a website with a database connected to a SQL server. I need
> to copy that database without the data onto a CD so I can place the
> program on another server?
> Any help would be greatly appreciated.
>sqlsql