Hello,
I was wondering if there is a tool available that maps the
relationships between tables in a SQL Server database.
I need this to help document a user guide to a DB I've designed for
them and they are familair with the MS Access diagrams and can't get
on with the diagrams Enterprise Manager produces.
However I want the tool to "attach" the relations to the Primary Key
and Foreign Keys regardless of where I drag the tables around, an
awful lot like MS Access relationship diagrams do. I've trawled
through many "trails" offered on the internet and thought I'd be
better off "asking the audience" for any recommendations.
Thanks for any help
Giles
If you want to document your database, you might check out SqlSpec, a
shareware app I wrote: http://www.elsasoft.org
Giles wrote:
>Hello,
>I was wondering if there is a tool available that maps the
>relationships between tables in a SQL Server database.
>I need this to help document a user guide to a DB I've designed for
>them and they are familair with the MS Access diagrams and can't get
>on with the diagrams Enterprise Manager produces.
>However I want the tool to "attach" the relations to the Primary Key
>and Foreign Keys regardless of where I drag the tables around, an
>awful lot like MS Access relationship diagrams do. I've trawled
>through many "trails" offered on the internet and thought I'd be
>better off "asking the audience" for any recommendations.
>Thanks for any help
>Giles
|||On 17 May, 21:29, "jezemine" <u34287@.uwe> wrote:
> If you want to document your database, you might check out SqlSpec, a
>
> shareware app I wrote:http://www.elsasoft.org
> Giles wrote:
>
>
> - Show quoted text -
Thanks for the tip, pretty looking app, but unfortunatley it still
doesn't map the relationships as I require.
Ta
Giles
sql
Showing posts with label available. Show all posts
Showing posts with label available. Show all posts
Wednesday, March 28, 2012
Friday, March 9, 2012
Regular expression..
Does SqlServer support Regular expression?
I want to know if it's avilable or not...
And if it's not available, I want to know any other efficient way to validate string.. manipulating Regular expression style validation.
Thank you all...use sp_oaxxx, works like a charm :)|||Transact-SQL 2000 supports a very crude, grep like set of regular expressions for the LIKE (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_la-lz_115x.asp) operator. I don't know of anything like the regular expressions in Perl, awk, vi, or gres within Transact-SQL (and would often kill for such a thing!). This is coming in Yukon, but that is still a ways off.
-PatP|||Pat, check this (http://www.sqlteam.com/item.asp?ItemID=13947) out, it may change your mind ;)|||That example gets you about 30% of grep, which is a considerable improvement over what LIKE gives you. It doesn't get any significant part of regexp as offered by Perl, awk, gres, etc.
I still use Perl when the going gets tough. Perl can open an ODBC connection, mangle the data, and be done before I could figure out how to identify the data that I needed to change using LIKE!
-PatP|||No pressure, just a thought ;)|||Thank you all for considering.
rdjabarov's link give that I really needed.
I want to know if it's avilable or not...
And if it's not available, I want to know any other efficient way to validate string.. manipulating Regular expression style validation.
Thank you all...use sp_oaxxx, works like a charm :)|||Transact-SQL 2000 supports a very crude, grep like set of regular expressions for the LIKE (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_la-lz_115x.asp) operator. I don't know of anything like the regular expressions in Perl, awk, vi, or gres within Transact-SQL (and would often kill for such a thing!). This is coming in Yukon, but that is still a ways off.
-PatP|||Pat, check this (http://www.sqlteam.com/item.asp?ItemID=13947) out, it may change your mind ;)|||That example gets you about 30% of grep, which is a considerable improvement over what LIKE gives you. It doesn't get any significant part of regexp as offered by Perl, awk, gres, etc.
I still use Perl when the going gets tough. Perl can open an ODBC connection, mangle the data, and be done before I could figure out how to identify the data that I needed to change using LIKE!
-PatP|||No pressure, just a thought ;)|||Thank you all for considering.
rdjabarov's link give that I really needed.
Wednesday, March 7, 2012
registry replication consistency in MSCS
Hi,
I'm using MSCS registry checkpointing to make sure my application data
written in registry will be available to other nodes when they become online.
I was wondering if the checkpoint operation is synchronous to the registry
write or is it possible that the registry write would be acknowledged but the
checkpoint would be delayed?
If the second option is possible than how can I guarentee that if a power
failure occurs right after the registry write was acknowledged that the
checkpoint was indeed written to quorum and would be available for the second
node when it becomes online?
Hi
Well, if your SAN and servers are not on UPS, and you have a power failure,
the OS might be in the middle of a write, resulting in a partial write. This
may lead to corruption in the registry or quorum drive.
If you have a cluster for high availability, you should have a reliable
power system, or at least a way to shut it down in an orderly fashion once
the UPS goes onto low power.
Unless you have an orderly server shutdown, don't expect anything to be 100%
once it comes up.
Why are you using the registry to persist data? Databases or XML files do
the job better.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"smadar" <smadar@.discussions.microsoft.com> wrote in message
news:4BB152CC-4455-4CDF-91D2-B39EEF2D1D6D@.microsoft.com...
> Hi,
> I'm using MSCS registry checkpointing to make sure my application data
> written in registry will be available to other nodes when they become
> online.
> I was wondering if the checkpoint operation is synchronous to the registry
> write or is it possible that the registry write would be acknowledged but
> the
> checkpoint would be delayed?
> If the second option is possible than how can I guarentee that if a power
> failure occurs right after the registry write was acknowledged that the
> checkpoint was indeed written to quorum and would be available for the
> second
> node when it becomes online?
|||Hi,
Let me clarify my question:
My worries are not on the shutdown scenario, but on the behavior of the
checkpoint mechanism.
I'm using the win32 reg function: ZwSetValueKey (from my driver) to set a
key registered with a cluster resource.
If this call returns success can I assume that the data was already written
to a checkpoint on the quorum device? Is it synchronous to the registry write
or the quorum may be updated in a later time?
Thanks.
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Well, if your SAN and servers are not on UPS, and you have a power failure,
> the OS might be in the middle of a write, resulting in a partial write. This
> may lead to corruption in the registry or quorum drive.
> If you have a cluster for high availability, you should have a reliable
> power system, or at least a way to shut it down in an orderly fashion once
> the UPS goes onto low power.
> Unless you have an orderly server shutdown, don't expect anything to be 100%
> once it comes up.
> Why are you using the registry to persist data? Databases or XML files do
> the job better.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "smadar" <smadar@.discussions.microsoft.com> wrote in message
> news:4BB152CC-4455-4CDF-91D2-B39EEF2D1D6D@.microsoft.com...
>
>
I'm using MSCS registry checkpointing to make sure my application data
written in registry will be available to other nodes when they become online.
I was wondering if the checkpoint operation is synchronous to the registry
write or is it possible that the registry write would be acknowledged but the
checkpoint would be delayed?
If the second option is possible than how can I guarentee that if a power
failure occurs right after the registry write was acknowledged that the
checkpoint was indeed written to quorum and would be available for the second
node when it becomes online?
Hi
Well, if your SAN and servers are not on UPS, and you have a power failure,
the OS might be in the middle of a write, resulting in a partial write. This
may lead to corruption in the registry or quorum drive.
If you have a cluster for high availability, you should have a reliable
power system, or at least a way to shut it down in an orderly fashion once
the UPS goes onto low power.
Unless you have an orderly server shutdown, don't expect anything to be 100%
once it comes up.
Why are you using the registry to persist data? Databases or XML files do
the job better.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"smadar" <smadar@.discussions.microsoft.com> wrote in message
news:4BB152CC-4455-4CDF-91D2-B39EEF2D1D6D@.microsoft.com...
> Hi,
> I'm using MSCS registry checkpointing to make sure my application data
> written in registry will be available to other nodes when they become
> online.
> I was wondering if the checkpoint operation is synchronous to the registry
> write or is it possible that the registry write would be acknowledged but
> the
> checkpoint would be delayed?
> If the second option is possible than how can I guarentee that if a power
> failure occurs right after the registry write was acknowledged that the
> checkpoint was indeed written to quorum and would be available for the
> second
> node when it becomes online?
|||Hi,
Let me clarify my question:
My worries are not on the shutdown scenario, but on the behavior of the
checkpoint mechanism.
I'm using the win32 reg function: ZwSetValueKey (from my driver) to set a
key registered with a cluster resource.
If this call returns success can I assume that the data was already written
to a checkpoint on the quorum device? Is it synchronous to the registry write
or the quorum may be updated in a later time?
Thanks.
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Well, if your SAN and servers are not on UPS, and you have a power failure,
> the OS might be in the middle of a write, resulting in a partial write. This
> may lead to corruption in the registry or quorum drive.
> If you have a cluster for high availability, you should have a reliable
> power system, or at least a way to shut it down in an orderly fashion once
> the UPS goes onto low power.
> Unless you have an orderly server shutdown, don't expect anything to be 100%
> once it comes up.
> Why are you using the registry to persist data? Databases or XML files do
> the job better.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "smadar" <smadar@.discussions.microsoft.com> wrote in message
> news:4BB152CC-4455-4CDF-91D2-B39EEF2D1D6D@.microsoft.com...
>
>
Subscribe to:
Posts (Atom)