I would definitely recommend generating scripts to move table schemas around
without any of the data. Make sure you script indexes, triggers, and keys.
They aren't scripted by default in SQL 7 (might be in SQL 2000, I have no
experience with SQL 2000 yet).

- Jim

-----Original Message-----
From: Ken Ponder [mailto:Ken.[Email Address Removed]
Sent: Wednesday, April 28, 2004 1:26 PM
To: LazyDBA.com Discussion
Subject: Re: Database schema import

Two quick ways I can think of.

1. Generate SQL Script using Enterprise Manager. Right click on database,
select all tasks, generate SQL scripts.

2. Use DTS Import/Export wizard. Again with EM, right click on database,
select export data. after registering target server, select the third
option, copy objects and data. On the next screen you'll see several
options, uncheck Copy Data.

HTH,
Ken

>>> Lonnye Blake Bower <[Email Address Removed] 04/28/04 02:23PM
>>>
Is there a way to import the schema (I need EMPTY TABLES) of one database to
a different server?
I see the import metadata, however cannot figure out how to get the schema
to transfer to the new server.
Thanks!
~lb

Lonnye Blake Bower
SQL Database Administrator
[Email Address Removed] | 213.739.5327 | www.citysearch.com
<www.citysearch.com>



***************************************************************************
"The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential, proprietary,
and/or privileged material. Any review, retransmission, dissemination or
other use of, or taking of any action in reliance upon, this information by
persons or entities other than the intended recipient is prohibited. If you
received this in error, please contact the sender and delete the material
from all computers."



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] ,
then respond to the confirmation email you get
For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page