I generated the database diagram thru Sql Server for both schemas.
How would one print out the whole schema diagram?
Company has no big printer which can do this.
Kinkos is an option. If so how would I copy or send a database diagram file
to them ?
thx a lot...Unfortunately you cannot move the diagram out to a Generic format.
You can only move from Database to another. Refer :
http://support.microsoft.com/defaul...b;en-us;Q320125
But here is a work around option for you, if you have Microsoft visio 2000.
You can Reverse Engineer a DB from Visio. Follow the Instructiopns Below.
After Reverse Engineering Save the Diagram as JPG or BMP, which is portable
HTH
Satish Balusa
Corillian Corp.
From BOL of visio 2000
To reverse engineer an existing database
1.. Choose File > New > Database > Database Model Diagram.
2.. Choose Database > Reverse Engineer.
3.. On the first screen of the Reverse Engineer Wizard, do the following:
a.. Select the visio database driver for your database management system
(DBMS).
If you have not already associated the visio database driver with a
particular 32-bit ODBC data source, do so now.
b.. Select the data source of the database you're updating.
If you have not already created a data source for the existing database,
do so now.
When you create a new source, your visio product adds its name to the
Data Sources list.
c.. When you are satisfied with your settings, click Next.
4.. Follow the instructions in any driver-specific dialog boxes.
For example, in the Connect Data Source dialog box, type a user name and
password, and then click OK.
5.. Check the boxes for the type of information you want to extract, and
then click Next.
6.. Check the tables (and views, if any) that you want to extract, or
click Select All to extract them all, and then click Next.
7.. If you checked Stored Procedures in step 5, on the next screen check
the procedures that you want to extract, or click Select All to extract them
all, and then click Next.
8.. Review your selections to verify that you are extracting the
information you want, and then click Finish.
The wizard extracts the selected information and displays notes about the
extraction process in the Output window.
9.. Create a diagram of your model by
a.. Dragging the tables you want to view from the Tables window onto the
drawing page.
b.. Using the Show Related Tables command to view the tables related to
a particular table.
"giny" <anonymous@.discussions.microsoft.com> wrote in message
news:45E8EC17-3B48-41F7-BF3D-4C5A6EC7D93C@.microsoft.com...
quote:
> I have 2 schemas. One with 90 tables and another with about 42 tables.
> I generated the database diagram thru Sql Server for both schemas.
> How would one print out the whole schema diagram?
> Company has no big printer which can do this.
> Kinkos is an option. If so how would I copy or send a database diagram
file to them ?
quote:
> thx a lot...
No comments:
Post a Comment