Hello,
I am new in database administration, I have a SQL 2000 database on server. I
need to see the architecture/design of the current running database. Is there
any tool or way to find or see the database architecture/design, so that I
can easily figure out the relations between different tables and understand
the database design.
Thanks in advance,
LeoUse "Create Database Diagram Wizard". Add all user tables into it, which will
give you a digramatic representation of the same. Hope this will help!!!
Thanks,
Sree
"Leo_Surf" wrote:
> Hello,
> I am new in database administration, I have a SQL 2000 database on server. I
> need to see the architecture/design of the current running database. Is there
> any tool or way to find or see the database architecture/design, so that I
> can easily figure out the relations between different tables and understand
> the database design.
> Thanks in advance,
> Leo|||Thanks Sree..
will I be able to see/understand database schema from the diagrams? or there
is any other way to do that? because in diagrams I am not able to see the
relationship betewwn the tables.
Thanks in advance...
Leo
"Sreejith G" wrote:
> Use "Create Database Diagram Wizard". Add all user tables into it, which will
> give you a digramatic representation of the same. Hope this will help!!!
> Thanks,
> Sree
> "Leo_Surf" wrote:
> > Hello,
> >
> > I am new in database administration, I have a SQL 2000 database on server. I
> > need to see the architecture/design of the current running database. Is there
> > any tool or way to find or see the database architecture/design, so that I
> > can easily figure out the relations between different tables and understand
> > the database design.
> >
> > Thanks in advance,
> > Leo|||Leo_Surf wrote:
> Thanks Sree..
> will I be able to see/understand database schema from the diagrams? or there
> is any other way to do that? because in diagrams I am not able to see the
> relationship betewwn the tables.
> Thanks in advance...
> Leo
>
The diagram should show relationships as long as the foreign keys
exist. Do they exist or are they missing from the diagram because they
aren't there? Use the Object Browser in Query Analyzer to check that
the foreign key constraints you expected are not missing.
Unfortunately Enterprise Manager's diagrams are extremely poor. They
don't use any of the proper notation for keys. They also don't easily
scale, print or embed in other documents. For any serious work you'll
want to consider using a different tool for diagrams such as Microsoft
Visio or ERwin.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
Showing posts with label design. Show all posts
Showing posts with label design. Show all posts
Sunday, March 11, 2012
Database architecture
Hello,
I am new in database administration, I have a SQL 2000 database on server. I
need to see the architecture/design of the current running database. Is there
any tool or way to find or see the database architecture/design, so that I
can easily figure out the relations between different tables and understand
the database design.
Thanks in advance,
Leo
Use "Create Database Diagram Wizard". Add all user tables into it, which will
give you a digramatic representation of the same. Hope this will help!!!
Thanks,
Sree
"Leo_Surf" wrote:
> Hello,
> I am new in database administration, I have a SQL 2000 database on server. I
> need to see the architecture/design of the current running database. Is there
> any tool or way to find or see the database architecture/design, so that I
> can easily figure out the relations between different tables and understand
> the database design.
> Thanks in advance,
> Leo
|||Thanks Sree..
will I be able to see/understand database schema from the diagrams? or there
is any other way to do that? because in diagrams I am not able to see the
relationship betewwn the tables.
Thanks in advance...
Leo
"Sreejith G" wrote:
[vbcol=seagreen]
> Use "Create Database Diagram Wizard". Add all user tables into it, which will
> give you a digramatic representation of the same. Hope this will help!!!
> Thanks,
> Sree
> "Leo_Surf" wrote:
|||Leo_Surf wrote:
> Thanks Sree..
> will I be able to see/understand database schema from the diagrams? or there
> is any other way to do that? because in diagrams I am not able to see the
> relationship betewwn the tables.
> Thanks in advance...
> Leo
>
The diagram should show relationships as long as the foreign keys
exist. Do they exist or are they missing from the diagram because they
aren't there? Use the Object Browser in Query Analyzer to check that
the foreign key constraints you expected are not missing.
Unfortunately Enterprise Manager's diagrams are extremely poor. They
don't use any of the proper notation for keys. They also don't easily
scale, print or embed in other documents. For any serious work you'll
want to consider using a different tool for diagrams such as Microsoft
Visio or ERwin.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
I am new in database administration, I have a SQL 2000 database on server. I
need to see the architecture/design of the current running database. Is there
any tool or way to find or see the database architecture/design, so that I
can easily figure out the relations between different tables and understand
the database design.
Thanks in advance,
Leo
Use "Create Database Diagram Wizard". Add all user tables into it, which will
give you a digramatic representation of the same. Hope this will help!!!
Thanks,
Sree
"Leo_Surf" wrote:
> Hello,
> I am new in database administration, I have a SQL 2000 database on server. I
> need to see the architecture/design of the current running database. Is there
> any tool or way to find or see the database architecture/design, so that I
> can easily figure out the relations between different tables and understand
> the database design.
> Thanks in advance,
> Leo
|||Thanks Sree..
will I be able to see/understand database schema from the diagrams? or there
is any other way to do that? because in diagrams I am not able to see the
relationship betewwn the tables.
Thanks in advance...
Leo
"Sreejith G" wrote:
[vbcol=seagreen]
> Use "Create Database Diagram Wizard". Add all user tables into it, which will
> give you a digramatic representation of the same. Hope this will help!!!
> Thanks,
> Sree
> "Leo_Surf" wrote:
|||Leo_Surf wrote:
> Thanks Sree..
> will I be able to see/understand database schema from the diagrams? or there
> is any other way to do that? because in diagrams I am not able to see the
> relationship betewwn the tables.
> Thanks in advance...
> Leo
>
The diagram should show relationships as long as the foreign keys
exist. Do they exist or are they missing from the diagram because they
aren't there? Use the Object Browser in Query Analyzer to check that
the foreign key constraints you expected are not missing.
Unfortunately Enterprise Manager's diagrams are extremely poor. They
don't use any of the proper notation for keys. They also don't easily
scale, print or embed in other documents. For any serious work you'll
want to consider using a different tool for diagrams such as Microsoft
Visio or ERwin.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
Database architecture
Hello,
I am new in database administration, I have a SQL 2000 database on server. I
need to see the architecture/design of the current running database. Is ther
e
any tool or way to find or see the database architecture/design, so that I
can easily figure out the relations between different tables and understand
the database design.
Thanks in advance,
LeoUse "Create Database Diagram Wizard". Add all user tables into it, which wil
l
give you a digramatic representation of the same. Hope this will help!!!
Thanks,
Sree
"Leo_Surf" wrote:
> Hello,
> I am new in database administration, I have a SQL 2000 database on server.
I
> need to see the architecture/design of the current running database. Is th
ere
> any tool or way to find or see the database architecture/design, so that I
> can easily figure out the relations between different tables and understan
d
> the database design.
> Thanks in advance,
> Leo|||Thanks Sree..
will I be able to see/understand database schema from the diagrams? or there
is any other way to do that? because in diagrams I am not able to see the
relationship betewwn the tables.
Thanks in advance...
Leo
"Sreejith G" wrote:
[vbcol=seagreen]
> Use "Create Database Diagram Wizard". Add all user tables into it, which w
ill
> give you a digramatic representation of the same. Hope this will help!!!
> Thanks,
> Sree
> "Leo_Surf" wrote:
>|||Leo_Surf wrote:
> Thanks Sree..
> will I be able to see/understand database schema from the diagrams? or the
re
> is any other way to do that? because in diagrams I am not able to see the
> relationship betewwn the tables.
> Thanks in advance...
> Leo
>
The diagram should show relationships as long as the foreign keys
exist. Do they exist or are they missing from the diagram because they
aren't there? Use the Object Browser in Query Analyzer to check that
the foreign key constraints you expected are not missing.
Unfortunately Enterprise Manager's diagrams are extremely poor. They
don't use any of the proper notation for keys. They also don't easily
scale, print or embed in other documents. For any serious work you'll
want to consider using a different tool for diagrams such as Microsoft
Visio or ERwin.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
I am new in database administration, I have a SQL 2000 database on server. I
need to see the architecture/design of the current running database. Is ther
e
any tool or way to find or see the database architecture/design, so that I
can easily figure out the relations between different tables and understand
the database design.
Thanks in advance,
LeoUse "Create Database Diagram Wizard". Add all user tables into it, which wil
l
give you a digramatic representation of the same. Hope this will help!!!
Thanks,
Sree
"Leo_Surf" wrote:
> Hello,
> I am new in database administration, I have a SQL 2000 database on server.
I
> need to see the architecture/design of the current running database. Is th
ere
> any tool or way to find or see the database architecture/design, so that I
> can easily figure out the relations between different tables and understan
d
> the database design.
> Thanks in advance,
> Leo|||Thanks Sree..
will I be able to see/understand database schema from the diagrams? or there
is any other way to do that? because in diagrams I am not able to see the
relationship betewwn the tables.
Thanks in advance...
Leo
"Sreejith G" wrote:
[vbcol=seagreen]
> Use "Create Database Diagram Wizard". Add all user tables into it, which w
ill
> give you a digramatic representation of the same. Hope this will help!!!
> Thanks,
> Sree
> "Leo_Surf" wrote:
>|||Leo_Surf wrote:
> Thanks Sree..
> will I be able to see/understand database schema from the diagrams? or the
re
> is any other way to do that? because in diagrams I am not able to see the
> relationship betewwn the tables.
> Thanks in advance...
> Leo
>
The diagram should show relationships as long as the foreign keys
exist. Do they exist or are they missing from the diagram because they
aren't there? Use the Object Browser in Query Analyzer to check that
the foreign key constraints you expected are not missing.
Unfortunately Enterprise Manager's diagrams are extremely poor. They
don't use any of the proper notation for keys. They also don't easily
scale, print or embed in other documents. For any serious work you'll
want to consider using a different tool for diagrams such as Microsoft
Visio or ERwin.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
Saturday, February 25, 2012
Data warehousing design
Hi
We are starting with designing a datawarehouse for my company. I have done some reading on the concepts and steps involved, but what I am seriously lacking is some examples. I'd like to read through some real examples of data warehouses that worked including the full design diagrams.
Can anyone direct me to some good sites for this?
Thanks,
TeaaZAIf you are building a true data warehouse, then get the books written by Bill Inmon. If you are building a small data mart, then you might consider Kimball's books.
We are starting with designing a datawarehouse for my company. I have done some reading on the concepts and steps involved, but what I am seriously lacking is some examples. I'd like to read through some real examples of data warehouses that worked including the full design diagrams.
Can anyone direct me to some good sites for this?
Thanks,
TeaaZAIf you are building a true data warehouse, then get the books written by Bill Inmon. If you are building a small data mart, then you might consider Kimball's books.
Data warehousing - Design
I'm designing data wareouse where I=B4m taking Data from an=20
operational Database, I=B4m creating dimension tables and=20
facta tables, my question is following.
When creating dimension tables I=B4m sometimes taking=20
column from tables in the operational database where=20
there is no indexing, should I create index for the=20
column in the data warehouse ?.
When creating facta tables and dimension tables for=20
Analyser services should I have dimension tables with=20
primary keys, and facta with foreign keys to the=20
dimension tables.
Does somone knows about some good article for designing=20
Data warehouse for Analyser services
Looking forward to hear from you
Regards
J=F3n SveinssonTry these
http://www.microsoft.com/technet/tr...part5/c2061.asp
http://www.ralphkimball.com/html/articles.html
HTH
Ray Higdon MCSE, MCDBA, CCNA
--
"Jn Sveinsson" <jon@.nordural.is> wrote in message
news:035701c3fab5$f1f389c0$a401280a@.phx.gbl...
I'm designing data wareouse where Im taking Data from an
operational Database, Im creating dimension tables and
facta tables, my question is following.
When creating dimension tables Im sometimes taking
column from tables in the operational database where
there is no indexing, should I create index for the
column in the data warehouse ?.
When creating facta tables and dimension tables for
Analyser services should I have dimension tables with
primary keys, and facta with foreign keys to the
dimension tables.
Does somone knows about some good article for designing
Data warehouse for Analyser services
Looking forward to hear from you
Regards
Jn Sveinsson
operational Database, I=B4m creating dimension tables and=20
facta tables, my question is following.
When creating dimension tables I=B4m sometimes taking=20
column from tables in the operational database where=20
there is no indexing, should I create index for the=20
column in the data warehouse ?.
When creating facta tables and dimension tables for=20
Analyser services should I have dimension tables with=20
primary keys, and facta with foreign keys to the=20
dimension tables.
Does somone knows about some good article for designing=20
Data warehouse for Analyser services
Looking forward to hear from you
Regards
J=F3n SveinssonTry these
http://www.microsoft.com/technet/tr...part5/c2061.asp
http://www.ralphkimball.com/html/articles.html
HTH
Ray Higdon MCSE, MCDBA, CCNA
--
"Jn Sveinsson" <jon@.nordural.is> wrote in message
news:035701c3fab5$f1f389c0$a401280a@.phx.gbl...
I'm designing data wareouse where Im taking Data from an
operational Database, Im creating dimension tables and
facta tables, my question is following.
When creating dimension tables Im sometimes taking
column from tables in the operational database where
there is no indexing, should I create index for the
column in the data warehouse ?.
When creating facta tables and dimension tables for
Analyser services should I have dimension tables with
primary keys, and facta with foreign keys to the
dimension tables.
Does somone knows about some good article for designing
Data warehouse for Analyser services
Looking forward to hear from you
Regards
Jn Sveinsson
Data warehouse forum
Hi, all,
Thanks for your kind attention.
Just have some enquries about some issues of data warehouse design and would like to hear from any of you for any prestigious forum on data warehouse?
Thanks a lot in advance and I am looking forward to hearing from you shortly.
With best regards,
Yours sincerely,
Check out http://www.kimballgroup.com/. They have a nice email newsletter with design tips.
I like the books by Ralph Kimball, particularly "The data warehouse toolkit."
Eric
|||Hi, Eric,
Thanks a lot for your help.
With kindest regards,
Yours sincerely,
Data warehouse forum
Hi, all,
Thanks for your kind attention.
Just have some enquries about some issues of data warehouse design and would like to hear from any of you for any prestigious forum on data warehouse?
Thanks a lot in advance and I am looking forward to hearing from you shortly.
With best regards,
Yours sincerely,
Check out http://www.kimballgroup.com/. They have a nice email newsletter with design tips.
I like the books by Ralph Kimball, particularly "The data warehouse toolkit."
Eric
|||Hi, Eric,
Thanks a lot for your help.
With kindest regards,
Yours sincerely,
Subscribe to:
Posts (Atom)