Hi folks!
I have a SQL sever installed in my laboratory and now I have to build a
database identical to a danish one (I write from Italy, the danish group
works on the same biological experiments and data) so I thought I can
tranfer the structure of that database into my SQL server (I dont' really
need to transfer data, just the schema). Is this possible? Even if we are
not in a LAN? How can I do it? Take care that I'm not a DBA (but I have to
become it...) and my experience with SQL server is quite little...

Davide

"dawe" <six_strings (AT) libero (DOT) it> wrote

If it's just the schema you want, then in Enterprise Manager right-click the
database and script it to a file. Make sure that you select all the objects
you want to re-create, including the database itself.

In the script file will be all the SQL commands to re-create the schema on
any SQL Server you wish.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.532 / Virus Database: 326 - Release Date: 27/10/2003

You will need to obtain the create table statements
from the danish database. One way of doing this is:

1) run Enterprise manager and go to the database tables
2) select/highlight the tables you want to copy and right click
3) select create scripts. (writes a text file)
4) transport the scripts to your machine (small text file)
5) run the create table scripts on your machine using Query Analyser
making sure to target your new database.


"dawe" <six_strings (AT) libero (DOT) it> wrote