Thank you all...
I got it to work by using the generate script option from the database.
I don't know why I did not think of that.
~lb

-----Original Message-----
From: Ken Ponder [mailto:Ken.[Email Address Removed]
Sent: Wednesday, April 28, 2004 12:26 PM
To: [Email Address Removed] [Email Address Removed] 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."
MS Sql Server LazyDBA home page