Showing posts with label tools. Show all posts
Showing posts with label tools. Show all posts

Wednesday, March 28, 2012

Regarding 3rd party SQL tools (Free Secure?)

Hi guys, I just curious about 3rd party tools whether there are free secure to use and any recommend tools for SQL? Currently I am using some tools like 'SQL Server Online Backup' and 'ApexSQL'. When I am using those 3rd party tools,is there any trace file or information (username & password) will be keep and send to other locations or 3rd party? Thanx and hope can get any assistance or opinion here. Have a nice day.

Best Regards,

Hans

Refer to http://www.sql-server-performance.com website and refer to the software spotlight for such information.

Moving to Tools section as per the subject relevancy.

Regarding 3rd party SQL tools (Free Secure?)

Hi guys, I just curious about 3rd party tools whether there are free secure to use and any recommend tools for SQL? Currently I am using some tools like 'SQL Server Online Backup' and 'ApexSQL'. When I am using those 3rd party tools,is there any trace file or information (username & password) will be keep and send to other locations or 3rd party? Thanx and hope can get any assistance or opinion here. Have a nice day.

Best Regards,

Hans

Refer to http://www.sql-server-performance.com website and refer to the software spotlight for such information.

Moving to Tools section as per the subject relevancy.

Wednesday, March 21, 2012

Referential Integrity

We are currently using Erwin for our Data Modeler, but wanted to know if
there are any good tools, or better data modelers, to help with our project
of referential integrity. Currently we use triggers to enforce our
referential integrity, but we would like to move towards using constraints to
enforce our data integrity. Currently using SQL Server 2000.SQL Server has a basic data modeler (diagrams) that allows you to create
foreign keys between tables. It is not as nice or powerful as Erwin, but it
gets the job done (and it is free).
If you want to stick with Microsoft products you could try using Visio. I
remember seeing database diagramming capabilities in some of the versions.
I haven't looked at the new Visual Studio offering, but they might have
something in there:
http://msdn.microsoft.com/vstudio/teamsystem/products/dbpro/default.aspx
Here are a few other tools that I am aware of:
WinSQL
http://synametrics.com/SynametricsWebApp/WinSQL.jsp
SQL Diagrams
http://www.skilledsoftware.com/sqldiagrams.htm
--
Keith Kratochvil
"Patrick" <Patrick@.discussions.microsoft.com> wrote in message
news:059856C5-B1EE-481D-A301-A93D62E11EAD@.microsoft.com...
> We are currently using Erwin for our Data Modeler, but wanted to know if
> there are any good tools, or better data modelers, to help with our
> project
> of referential integrity. Currently we use triggers to enforce our
> referential integrity, but we would like to move towards using constraints
> to
> enforce our data integrity. Currently using SQL Server 2000.