How to save entire database structure without data?

I want to save a complete copy of the database structure without any of the
data. Tables, Sprocs, Permissions, Triggers, etc.
How do I go about doing this and getting EVERYTHING except the data? Thanks
On Dec 11, 12:13 pm, "JTMZ" <J...@.hotmail.com> wrote:
> I want to save a complete copy of the database structure without any of the
> data. Tables, Sprocs, Permissions, Triggers, etc.
> How do I go about doing this and getting EVERYTHING except the data? Thanks
You can create script for the entire object in the database. Right
click on the database and select Tasks then Generate Scripts which
will open a window of SQL Server Scripts Wizard. The rest is self
explanotary.
Bulent

How to save entire database structure without data?

I want to save a complete copy of the database structure without any of the
data. Tables, Sprocs, Permissions, Triggers, etc.
How do I go about doing this and getting EVERYTHING except the data? ThanksOn Dec 11, 12:13 pm, "JTMZ" <J...@.hotmail.com> wrote:
> I want to save a complete copy of the database structure without any of the
> data. Tables, Sprocs, Permissions, Triggers, etc.
> How do I go about doing this and getting EVERYTHING except the data? Thanks
You can create script for the entire object in the database. Right
click on the database and select Tasks then Generate Scripts which
will open a window of SQL Server Scripts Wizard. The rest is self
explanotary.
Bulentsql

How to save entire database structure without data?

I want to save a complete copy of the database structure without any of the
data. Tables, Sprocs, Permissions, Triggers, etc.
How do I go about doing this and getting EVERYTHING except the data? ThanksOn Dec 11, 12:13 pm, "JTMZ" <J...@.hotmail.com> wrote:[vbcol=seagreen]
> I want to save a complete copy of the database structure without any of th
e
> data. Tables, Sprocs, Permissions, Triggers, etc.
> How do I go about doing this and getting EVERYTHING except the data? Thanks[/vbco
l]
You can create script for the entire object in the database. Right
click on the database and select Tasks then Generate Scripts which
will open a window of SQL Server Scripts Wizard. The rest is self
explanotary.
Bulent

How to restore, transfer or copy a sql 2005 database to sql 2000 server

Because I'm stupid I assumed, it would be simple to move a sql server 2005 database to sql server 2000, if I don't use special 2005 features. But restore completely not work. No option in case of restore?

OK - there are some hints about using export etc. in

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=166196&SiteID=1

But it seems to be not so easy. Can someone please explain, how to do this move step by step? I need complete transfer for all objects, including fulltext, indexes, triggers and data. Can I use BCP :-( ?

Many thanks for help - I run into real trubble with this...

fd2000

The on-disk format of SQL databases has changed between SQL 2000 and SQL 2005. That is why you cannot restore a SQL 2005 backup onto a SQL 2000 instance. This is not going to change.

So, your options are to find a way to make SQL 2005 work for you, or to export your data, and re-import into a SQL 2000 instance. BCP should work for this. Use the BCP80 option which ensures that no SQL 2005 options are used. Note that if you have added anything which relies on a SQL2005 feature, it will not be fully transferred to your SQL 2000 instance. (UDTs come across as LOBs, etc.)

|||

You have to install a instance of sql server 2000 and export the data/object back to it else u have to make your sql server 2005 work for u.

sanjeevupd