Hi want to produce a DB diagram on MSQSL 2000.
all I want to do is create links which exist diagrammatically only.
Instead as I UNDERSTAND it the SQL wants to physically create these
constraints on the DB. I DO NOT WANT THIS.
Pls don't answer that I should be using constraints, FK etcs. Not my
call and too late.
Is it possible to simply produce a diagram where I draw links between
fields without effecting underlying DB.
Is there a tool that will do this? Or should I just throw it into word
and make the links myself or use Visio. Preferably would like to
create diagram in MMSQL but which didn't change underlying DB.
Itzik, shalom
I'm afraid you are not able to do that with SQL Server.
Perhaps , there are some third part software to be able to do it for you.
"Yitzak" <terryshamir@.yahoo.co.uk> wrote in message
news:b73ddf3c.0503290417.8baa183@.posting.google.co m...
> Hi want to produce a DB diagram on MSQSL 2000.
> all I want to do is create links which exist diagrammatically only.
> Instead as I UNDERSTAND it the SQL wants to physically create these
> constraints on the DB. I DO NOT WANT THIS.
> Pls don't answer that I should be using constraints, FK etcs. Not my
> call and too late.
> Is it possible to simply produce a diagram where I draw links between
> fields without effecting underlying DB.
> Is there a tool that will do this? Or should I just throw it into word
> and make the links myself or use Visio. Preferably would like to
> create diagram in MMSQL but which didn't change underlying DB.
|||I generally use Visio for this... But you could use any 3rd party modelling
tool like Erwin, you'd have to set up the PK, FK etc in the logical
model... Just don't push it out to the physical database
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Yitzak" <terryshamir@.yahoo.co.uk> wrote in message
news:b73ddf3c.0503290417.8baa183@.posting.google.co m...
> Hi want to produce a DB diagram on MSQSL 2000.
> all I want to do is create links which exist diagrammatically only.
> Instead as I UNDERSTAND it the SQL wants to physically create these
> constraints on the DB. I DO NOT WANT THIS.
> Pls don't answer that I should be using constraints, FK etcs. Not my
> call and too late.
> Is it possible to simply produce a diagram where I draw links between
> fields without effecting underlying DB.
> Is there a tool that will do this? Or should I just throw it into word
> and make the links myself or use Visio. Preferably would like to
> create diagram in MMSQL but which didn't change underlying DB.
Showing posts with label diagrammatically. Show all posts
Showing posts with label diagrammatically. Show all posts
Sunday, March 11, 2012
Diagrams a tool anyone can recommend
Hi want to produce a DB diagram on MSQSL 2000.
all I want to do is create links which exist diagrammatically only.
Instead as I UNDERSTAND it the SQL wants to physically create these
constraints on the DB. I DO NOT WANT THIS.
Pls don't answer that I should be using constraints, FK etcs. Not my
call and too late.
Is it possible to simply produce a diagram where I draw links between
fields without effecting underlying DB.
Is there a tool that will do this? Or should I just throw it into word
and make the links myself or use Visio. Preferably would like to
create diagram in MMSQL but which didn't change underlying DB.Itzik, shalom
I'm afraid you are not able to do that with SQL Server.
Perhaps , there are some third part software to be able to do it for you.
"Yitzak" <terryshamir@.yahoo.co.uk> wrote in message
news:b73ddf3c.0503290417.8baa183@.posting.google.com...
> Hi want to produce a DB diagram on MSQSL 2000.
> all I want to do is create links which exist diagrammatically only.
> Instead as I UNDERSTAND it the SQL wants to physically create these
> constraints on the DB. I DO NOT WANT THIS.
> Pls don't answer that I should be using constraints, FK etcs. Not my
> call and too late.
> Is it possible to simply produce a diagram where I draw links between
> fields without effecting underlying DB.
> Is there a tool that will do this? Or should I just throw it into word
> and make the links myself or use Visio. Preferably would like to
> create diagram in MMSQL but which didn't change underlying DB.|||I generally use visio for this... But you could use any 3rd party modelling
tool like Erwin, you'd have to set up the PK, FK etc in the logical
model... Just don't push it out to the physical database
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Yitzak" <terryshamir@.yahoo.co.uk> wrote in message
news:b73ddf3c.0503290417.8baa183@.posting.google.com...
> Hi want to produce a DB diagram on MSQSL 2000.
> all I want to do is create links which exist diagrammatically only.
> Instead as I UNDERSTAND it the SQL wants to physically create these
> constraints on the DB. I DO NOT WANT THIS.
> Pls don't answer that I should be using constraints, FK etcs. Not my
> call and too late.
> Is it possible to simply produce a diagram where I draw links between
> fields without effecting underlying DB.
> Is there a tool that will do this? Or should I just throw it into word
> and make the links myself or use Visio. Preferably would like to
> create diagram in MMSQL but which didn't change underlying DB.
all I want to do is create links which exist diagrammatically only.
Instead as I UNDERSTAND it the SQL wants to physically create these
constraints on the DB. I DO NOT WANT THIS.
Pls don't answer that I should be using constraints, FK etcs. Not my
call and too late.
Is it possible to simply produce a diagram where I draw links between
fields without effecting underlying DB.
Is there a tool that will do this? Or should I just throw it into word
and make the links myself or use Visio. Preferably would like to
create diagram in MMSQL but which didn't change underlying DB.Itzik, shalom
I'm afraid you are not able to do that with SQL Server.
Perhaps , there are some third part software to be able to do it for you.
"Yitzak" <terryshamir@.yahoo.co.uk> wrote in message
news:b73ddf3c.0503290417.8baa183@.posting.google.com...
> Hi want to produce a DB diagram on MSQSL 2000.
> all I want to do is create links which exist diagrammatically only.
> Instead as I UNDERSTAND it the SQL wants to physically create these
> constraints on the DB. I DO NOT WANT THIS.
> Pls don't answer that I should be using constraints, FK etcs. Not my
> call and too late.
> Is it possible to simply produce a diagram where I draw links between
> fields without effecting underlying DB.
> Is there a tool that will do this? Or should I just throw it into word
> and make the links myself or use Visio. Preferably would like to
> create diagram in MMSQL but which didn't change underlying DB.|||I generally use visio for this... But you could use any 3rd party modelling
tool like Erwin, you'd have to set up the PK, FK etc in the logical
model... Just don't push it out to the physical database
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Yitzak" <terryshamir@.yahoo.co.uk> wrote in message
news:b73ddf3c.0503290417.8baa183@.posting.google.com...
> Hi want to produce a DB diagram on MSQSL 2000.
> all I want to do is create links which exist diagrammatically only.
> Instead as I UNDERSTAND it the SQL wants to physically create these
> constraints on the DB. I DO NOT WANT THIS.
> Pls don't answer that I should be using constraints, FK etcs. Not my
> call and too late.
> Is it possible to simply produce a diagram where I draw links between
> fields without effecting underlying DB.
> Is there a tool that will do this? Or should I just throw it into word
> and make the links myself or use Visio. Preferably would like to
> create diagram in MMSQL but which didn't change underlying DB.
Diagrams a tool anyone can recommend
Hi want to produce a DB diagram on MSQSL 2000.
all I want to do is create links which exist diagrammatically only.
Instead as I UNDERSTAND it the SQL wants to physically create these
constraints on the DB. I DO NOT WANT THIS.
Pls don't answer that I should be using constraints, FK etcs. Not my
call and too late.
Is it possible to simply produce a diagram where I draw links between
fields without effecting underlying DB.
Is there a tool that will do this? Or should I just throw it into word
and make the links myself or use Visio. Preferably would like to
create diagram in MMSQL but which didn't change underlying DB.Itzik, shalom
I'm afraid you are not able to do that with SQL Server.
Perhaps , there are some third part software to be able to do it for you.
"Yitzak" <terryshamir@.yahoo.co.uk> wrote in message
news:b73ddf3c.0503290417.8baa183@.posting.google.com...
> Hi want to produce a DB diagram on MSQSL 2000.
> all I want to do is create links which exist diagrammatically only.
> Instead as I UNDERSTAND it the SQL wants to physically create these
> constraints on the DB. I DO NOT WANT THIS.
> Pls don't answer that I should be using constraints, FK etcs. Not my
> call and too late.
> Is it possible to simply produce a diagram where I draw links between
> fields without effecting underlying DB.
> Is there a tool that will do this? Or should I just throw it into word
> and make the links myself or use Visio. Preferably would like to
> create diagram in MMSQL but which didn't change underlying DB.|||I generally use Visio for this... But you could use any 3rd party modelling
tool like Erwin, you'd have to set up the PK, FK etc in the logical
model... Just don't push it out to the physical database
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Yitzak" <terryshamir@.yahoo.co.uk> wrote in message
news:b73ddf3c.0503290417.8baa183@.posting.google.com...
> Hi want to produce a DB diagram on MSQSL 2000.
> all I want to do is create links which exist diagrammatically only.
> Instead as I UNDERSTAND it the SQL wants to physically create these
> constraints on the DB. I DO NOT WANT THIS.
> Pls don't answer that I should be using constraints, FK etcs. Not my
> call and too late.
> Is it possible to simply produce a diagram where I draw links between
> fields without effecting underlying DB.
> Is there a tool that will do this? Or should I just throw it into word
> and make the links myself or use Visio. Preferably would like to
> create diagram in MMSQL but which didn't change underlying DB.|||I have used Erwin for several years. I have created
diagrams of what the database I am working on should look
like when I am done with it. Just reverse engineer it and
make all the connections.
Gary.
>--Original Message--
>Hi want to produce a DB diagram on MSQSL 2000.
>all I want to do is create links which exist
diagrammatically only.
>Instead as I UNDERSTAND it the SQL wants to physically
create these
>constraints on the DB. I DO NOT WANT THIS.
>Pls don't answer that I should be using constraints, FK
etcs. Not my
>call and too late.
>Is it possible to simply produce a diagram where I draw
links between
>fields without effecting underlying DB.
>Is there a tool that will do this? Or should I just throw
it into word
>and make the links myself or use Visio. Preferably would
like to
>create diagram in MMSQL but which didn't change underlying DB.
>.
>
all I want to do is create links which exist diagrammatically only.
Instead as I UNDERSTAND it the SQL wants to physically create these
constraints on the DB. I DO NOT WANT THIS.
Pls don't answer that I should be using constraints, FK etcs. Not my
call and too late.
Is it possible to simply produce a diagram where I draw links between
fields without effecting underlying DB.
Is there a tool that will do this? Or should I just throw it into word
and make the links myself or use Visio. Preferably would like to
create diagram in MMSQL but which didn't change underlying DB.Itzik, shalom
I'm afraid you are not able to do that with SQL Server.
Perhaps , there are some third part software to be able to do it for you.
"Yitzak" <terryshamir@.yahoo.co.uk> wrote in message
news:b73ddf3c.0503290417.8baa183@.posting.google.com...
> Hi want to produce a DB diagram on MSQSL 2000.
> all I want to do is create links which exist diagrammatically only.
> Instead as I UNDERSTAND it the SQL wants to physically create these
> constraints on the DB. I DO NOT WANT THIS.
> Pls don't answer that I should be using constraints, FK etcs. Not my
> call and too late.
> Is it possible to simply produce a diagram where I draw links between
> fields without effecting underlying DB.
> Is there a tool that will do this? Or should I just throw it into word
> and make the links myself or use Visio. Preferably would like to
> create diagram in MMSQL but which didn't change underlying DB.|||I generally use Visio for this... But you could use any 3rd party modelling
tool like Erwin, you'd have to set up the PK, FK etc in the logical
model... Just don't push it out to the physical database
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Yitzak" <terryshamir@.yahoo.co.uk> wrote in message
news:b73ddf3c.0503290417.8baa183@.posting.google.com...
> Hi want to produce a DB diagram on MSQSL 2000.
> all I want to do is create links which exist diagrammatically only.
> Instead as I UNDERSTAND it the SQL wants to physically create these
> constraints on the DB. I DO NOT WANT THIS.
> Pls don't answer that I should be using constraints, FK etcs. Not my
> call and too late.
> Is it possible to simply produce a diagram where I draw links between
> fields without effecting underlying DB.
> Is there a tool that will do this? Or should I just throw it into word
> and make the links myself or use Visio. Preferably would like to
> create diagram in MMSQL but which didn't change underlying DB.|||I have used Erwin for several years. I have created
diagrams of what the database I am working on should look
like when I am done with it. Just reverse engineer it and
make all the connections.
Gary.
>--Original Message--
>Hi want to produce a DB diagram on MSQSL 2000.
>all I want to do is create links which exist
diagrammatically only.
>Instead as I UNDERSTAND it the SQL wants to physically
create these
>constraints on the DB. I DO NOT WANT THIS.
>Pls don't answer that I should be using constraints, FK
etcs. Not my
>call and too late.
>Is it possible to simply produce a diagram where I draw
links between
>fields without effecting underlying DB.
>Is there a tool that will do this? Or should I just throw
it into word
>and make the links myself or use Visio. Preferably would
like to
>create diagram in MMSQL but which didn't change underlying DB.
>.
>
Subscribe to:
Posts (Atom)