Does Microsoft SQl Server has a connectivity tool over AIX?

Does Microsoft SQl Server has a connectivity tool over AIX?You need a thrid party ODBC driver, such as the one by DataDirect:

http://www.datadirect.com/index.ssp

It works quite nicely.|||How does it works when i try to retrieve data from MS SQL Server database table to a script running on AIX?|||the install is well documented...and they even have a video tuturorial on their website on it's basic use.

Does anyone know of a web based SQL Query tool?

Hi

I want to be able t give my users access to our SQL server database via a eb application published o our web server. I have found one freeware tool but it only supports SQL Server 2000 and the developer doesn't returns any emails.

Has anyone come across a web ui SQL query tool either freeware or one that can be purhcase

thanks for your help

Marcus

Do you just want to have a tool sending out a query from a textbox and getting the results back in a grid or something ? Or do you want tome graphical designer for your users ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

search for

SQL Server Web Data Administrator

on microsoft website

|||

Here is the link to SQL Server Web Data Administrator

http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en

Sethu Srinivasan, Software Design Engineer, SQL Server Manageability
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

|||ASP Enterprise Manager http://sourceforge.net/projects/asp-ent-man/

Does anyone know of a tool that allows a SQL Server database to be

Does anyone know of a web based tool that allows a SQL Server database
to be
adminstered from the Internet? (in php)Does anyone know of a web based tool that allows a SQL Server database

Quote:

Originally Posted by

to be adminstered from the Internet? (in php)

It's not in PHP but you can have a look at
myLittleAdmin for SQL Server 2005
and myLittleAdmin for SQL Server 2000
on http://www.mylittletools.net

Both have a free lite edition

Best regards

|||Not sure if it's sufficient for your purpose but have a look at MS SQL
Server Web Data Administrator
http://www.microsoft.com/downloads/...&displaylang=en

Markus

Does anyone have any ideas ..

... on making a DB map?
Hopefully someone knows of a tool/util.
Here's where I'm coming from:
We have a list of changes to make to our DB and the PHP interface.
I'd like to put together a list (map) of every table referenced on
each php page, as well as one showing every php page which uses each
table.
I'd like to have this as a reference so that when we bring in a
programmer, they can work more efficiently and be less likely to
create bugs.
Any ideas?
-Mo
Do you mean an ERD? How about using the diagram tool built into SQL Server.
If you are on 2000 it can be found in Enterprise Manage and if 2005 in SSMS.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Mo" <Mehile.Orloff@.gmail.com> wrote in message
news:6db5c30c-f1a4-4725-831a-790fa7dbd3de@.s19g2000prg.googlegroups.com...
> .. on making a DB map?
> Hopefully someone knows of a tool/util.
> Here's where I'm coming from:
> We have a list of changes to make to our DB and the PHP interface.
> I'd like to put together a list (map) of every table referenced on
> each php page, as well as one showing every php page which uses each
> table.
> I'd like to have this as a reference so that when we bring in a
> programmer, they can work more efficiently and be less likely to
> create bugs.
> Any ideas?
> -Mo
|||On Mar 3, 5:33Xpm, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
wrote:
> Do you mean an ERD? XHow about using the diagram tool built into SQL Server.
> If you are on 2000 it can be found in Enterprise Manage and if 2005 in SSMS.
> --
> Andrew J. Kelly X XSQL MVP
> Solid Quality Mentors
> "Mo" <Mehile.Orl...@.gmail.com> wrote in message
> news:6db5c30c-f1a4-4725-831a-790fa7dbd3de@.s19g2000prg.googlegroups.com...
>
>
>
>
>
> - Show quoted text -
Thanks for the suggestions.
I'll start there.
-Mo

Does anyone have any ideas ..

.. on making a DB map?
Hopefully someone knows of a tool/util.
Here's where I'm coming from:
We have a list of changes to make to our DB and the PHP interface.
I'd like to put together a list (map) of every table referenced on
each php page, as well as one showing every php page which uses each
table.
I'd like to have this as a reference so that when we bring in a
programmer, they can work more efficiently and be less likely to
create bugs.
Any ideas?
-MoDo you mean an ERD? How about using the diagram tool built into SQL Server.
If you are on 2000 it can be found in Enterprise Manage and if 2005 in SSMS.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Mo" <Mehile.Orloff@.gmail.com> wrote in message
news:6db5c30c-f1a4-4725-831a-790fa7dbd3de@.s19g2000prg.googlegroups.com...
> .. on making a DB map?
> Hopefully someone knows of a tool/util.
> Here's where I'm coming from:
> We have a list of changes to make to our DB and the PHP interface.
> I'd like to put together a list (map) of every table referenced on
> each php page, as well as one showing every php page which uses each
> table.
> I'd like to have this as a reference so that when we bring in a
> programmer, they can work more efficiently and be less likely to
> create bugs.
> Any ideas?
> -Mo|||On Mar 3, 5:33=A0pm, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
wrote:
> Do you mean an ERD? =A0How about using the diagram tool built into SQL Ser=ver.
> If you are on 2000 it can be found in Enterprise Manage and if 2005 in SSM=S.
> --
> Andrew J. Kelly =A0 =A0SQL MVP
> Solid Quality Mentors
> "Mo" <Mehile.Orl...@.gmail.com> wrote in message
> news:6db5c30c-f1a4-4725-831a-790fa7dbd3de@.s19g2000prg.googlegroups.com...
>
> > .. on making a DB map?
> > Hopefully someone knows of a tool/util.
> > Here's where I'm coming from:
> > We have a list of changes to make to our DB and the PHP interface.
> > I'd like to put together a list (map) of every table referenced on
> > each php page, as well as one showing every php page which uses each
> > table.
> > I'd like to have this as a reference so that when we bring in a
> > programmer, they can work more efficiently and be less likely to
> > create bugs.
> > Any ideas?
> > -Mo- Hide quoted text -
> - Show quoted text -
Thanks for the suggestions.
I'll start there.
-Mo

Does a tool like this exist?

Hi:
I am looking for a tool/utility that can compare 2 tables (indexes and
constraints etc.) and create a SQL script containing 'ALTER TABLE ...'
statements that would update the second table so it is the same as the first
table.
Does anything like this exist? It's a bit of a long-shot isn't it?
TIA,
MartinH.
Red Gate has a tool called SQL Compare
http://www.red-gate.com/
--Keith
"Martin Hart - Memory Soft, S.L." <memorysoftsl _at_ infotelecom _dot_ es>
wrote in message news:O8IXekOQFHA.244@.TK2MSFTNGP12.phx.gbl...
> Hi:
> I am looking for a tool/utility that can compare 2 tables (indexes and
> constraints etc.) and create a SQL script containing 'ALTER TABLE ...'
> statements that would update the second table so it is the same as the
> first table.
> Does anything like this exist? It's a bit of a long-shot isn't it?
> TIA,
> MartinH.
>
|||Hi,
SQLCompare is an excellent tool to compare and generate the script for the
differences between databases.
Try out the 14 day trial.
http://www.red-gate.com/SQL_Compare.htm
Thanks
Hari
SQL Server MVP
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:%23ux6lzOQFHA.3928@.TK2MSFTNGP09.phx.gbl...
> Red Gate has a tool called SQL Compare
> http://www.red-gate.com/
> --Keith
> "Martin Hart - Memory Soft, S.L." <memorysoftsl _at_ infotelecom _dot_ es>
> wrote in message news:O8IXekOQFHA.244@.TK2MSFTNGP12.phx.gbl...
>
|||Martin Hart - Memory Soft, S.L. wrote:
> Hi:
> I am looking for a tool/utility that can compare 2 tables (indexes and
> constraints etc.) and create a SQL script containing 'ALTER TABLE ...'
> statements that would update the second table so it is the same as
> the first table.
> Does anything like this exist? It's a bit of a long-shot isn't it?
>
Imceda offers Speed Change Manager. 14-day trial on web site.
David Gugick
Imceda Software
www.imceda.com
|||Keith:
Thanks, looks *very* interesting.
Regards,
MartinH.
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> escribi en el mensaje
news:%23ux6lzOQFHA.3928@.TK2MSFTNGP09.phx.gbl...
> Red Gate has a tool called SQL Compare
> http://www.red-gate.com/
> --Keith
> "Martin Hart - Memory Soft, S.L." <memorysoftsl _at_ infotelecom _dot_ es>
> wrote in message news:O8IXekOQFHA.244@.TK2MSFTNGP12.phx.gbl...
>
|||Innovartis does DB Ghost - more than a comparison tool - 30 day trial
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Build, Comparison and Synchronization from Source Control = Database change
management for SQL Server
"Martin Hart - Memory Soft, S.L." wrote:

> Hi:
> I am looking for a tool/utility that can compare 2 tables (indexes and
> constraints etc.) and create a SQL script containing 'ALTER TABLE ...'
> statements that would update the second table so it is the same as the first
> table.
> Does anything like this exist? It's a bit of a long-shot isn't it?
> TIA,
> MartinH.
>
>
|||Could you tell me Where is the web site ?
Thanks a lot
"mark baekdal" <markbaekdal@.discussions.microsoft.com> glsD:F9AC3991-7F4F-4C29-BA6D-0D52E03FB1C5@.microsoft.com...[vbcol=seagreen]
> Innovartis does DB Ghost - more than a comparison tool - 30 day trial
>
> regards,
> Mark Baekdal
> http://www.dbghost.com
> http://www.innovartis.co.uk
> +44 (0)208 241 1762
> Build, Comparison and Synchronization from Source Control = Database
> change
> management for SQL Server
>
>
> "Martin Hart - Memory Soft, S.L." wrote:
|||http://www.dbghost.com
"Agnes" wrote:

> Could you tell me Where is the web site ?
> Thanks a lot
> "mark baekdal" <markbaekdal@.discussions.microsoft.com> ???g?ó?l￥ó·s?D:F9AC3991-7F4F-4C29-BA6D-0D52E03FB1C5@.microsoft.com...
>
>

Documenting SQL Tables

Is there a documenting tool for tables on SQL Server 2000?Depends a bit on what documenting you intend to do....
Visio has a option to "reverse engineer" a database, but I'm not sure if
that's what you mean...?
Lee-Z
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:77FFE09C-F395-4FCD-B1C6-A643070103B7@.microsoft.com...
> Is there a documenting tool for tables on SQL Server 2000?|||I need to document the "Table Name", "Column Name", "Data Type", "Size",
"Lee-Z" wrote:
> Depends a bit on what documenting you intend to do....
> Visio has a option to "reverse engineer" a database, but I'm not sure if
> that's what you mean...?
> Lee-Z
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:77FFE09C-F395-4FCD-B1C6-A643070103B7@.microsoft.com...
> > Is there a documenting tool for tables on SQL Server 2000?
>
>|||Try something like
select a.name [Table],
b.name [Column],
b.xusertype [Type],
b.length [Length]
from sysobjects a joine syscolumns b on b.id=a.id
order by a.name,b.colorder, b.name
Or you could generate a SQL script for the DDL in the 'All Tasks' path
through enterprise manager.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Chris" wrote:
> I need to document the "Table Name", "Column Name", "Data Type", "Size",
> "Lee-Z" wrote:
> > Depends a bit on what documenting you intend to do....
> >
> > Visio has a option to "reverse engineer" a database, but I'm not sure if
> > that's what you mean...?
> >
> > Lee-Z
> >
> > "Chris" <Chris@.discussions.microsoft.com> wrote in message
> > news:77FFE09C-F395-4FCD-B1C6-A643070103B7@.microsoft.com...
> > > Is there a documenting tool for tables on SQL Server 2000?
> >
> >
> >|||On Fri, 12 Aug 2005 04:18:12 -0700, "Chris"
<Chris@.discussions.microsoft.com> wrote:
>Is there a documenting tool for tables on SQL Server 2000?
Also, the diagrams facility in Enterprise Manager!
J.|||On Fri, 12 Aug 2005 04:18:12 -0700, "Chris"
<Chris@.discussions.microsoft.com> wrote:
>Is there a documenting tool for tables on SQL Server 2000?
Look up Information_schema in BOL.
Also various sp_help SPs, like sp_helpindex.
J.|||Hi,
All the extended properties will be stored in "sysproperties" system table
of each database.
Eg:
CREATE table test (id int , name char (20))
go
EXEC sp_addextendedproperty 'caption', 'Employee ID', 'user', dbo,
'table', 'test', 'column', id
go
EXEC sp_addextendedproperty 'caption', 'Employee Name', 'user', dbo,
'table', 'test', 'column', name
go
select * from sysproperties where object_name(id)='test'
Instead of querying the system tables use the below code using functions to
get the extended properties,
SELECT * FROM ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table',
'test', 'column', default)
APEXSQL had got a very good tool for documentation.
http://www.apexsql.com/sql_tools_doc.asp
Thanks
Hari
SQL Server MVP
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:77FFE09C-F395-4FCD-B1C6-A643070103B7@.microsoft.com...
> Is there a documenting tool for tables on SQL Server 2000?|||Hello,
I've created a free tool for this. You can find it at
http://sydi.sourceforge.net, it can create documentation in MS Word and XML.
The tool for SQL is SYDI-SQL, on the page there are also tools for
documenting Windows servers and MS Exchange.
Best regards
Patrick Ogenstad
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ugvQXg2nFHA.1996@.TK2MSFTNGP10.phx.gbl...
> Hi,
> All the extended properties will be stored in "sysproperties" system table
> of each database.
> Eg:
> CREATE table test (id int , name char (20))
> go
> EXEC sp_addextendedproperty 'caption', 'Employee ID', 'user', dbo,
> 'table', 'test', 'column', id
> go
> EXEC sp_addextendedproperty 'caption', 'Employee Name', 'user', dbo,
> 'table', 'test', 'column', name
> go
> select * from sysproperties where object_name(id)='test'
>
> Instead of querying the system tables use the below code using functions
to
> get the extended properties,
>
> SELECT * FROM ::fn_listextendedproperty (NULL, 'user', 'dbo',
'table',
> 'test', 'column', default)
>
> APEXSQL had got a very good tool for documentation.
>
> http://www.apexsql.com/sql_tools_doc.asp
>
> Thanks
> Hari
> SQL Server MVP
>
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:77FFE09C-F395-4FCD-B1C6-A643070103B7@.microsoft.com...
> > Is there a documenting tool for tables on SQL Server 2000?
>

Documenting SQL Tables

Is there a documenting tool for tables on SQL Server 2000?
Depends a bit on what documenting you intend to do....
Visio has a option to "reverse engineer" a database, but I'm not sure if
that's what you mean...?
Lee-Z
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:77FFE09C-F395-4FCD-B1C6-A643070103B7@.microsoft.com...
> Is there a documenting tool for tables on SQL Server 2000?
|||I need to document the "Table Name", "Column Name", "Data Type", "Size",
"Lee-Z" wrote:

> Depends a bit on what documenting you intend to do....
> Visio has a option to "reverse engineer" a database, but I'm not sure if
> that's what you mean...?
> Lee-Z
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:77FFE09C-F395-4FCD-B1C6-A643070103B7@.microsoft.com...
>
>
|||Try something like
select a.name [Table],
b.name [Column],
b.xusertype [Type],
b.length [Length]
from sysobjects a joine syscolumns b on b.id=a.id
order by a.name,b.colorder, b.name
Or you could generate a SQL script for the DDL in the 'All Tasks' path
through enterprise manager.
Joseph R.P. Maloney, CSP,CCP,CDP
"Chris" wrote:
[vbcol=seagreen]
> I need to document the "Table Name", "Column Name", "Data Type", "Size",
> "Lee-Z" wrote:
|||On Fri, 12 Aug 2005 04:18:12 -0700, "Chris"
<Chris@.discussions.microsoft.com> wrote:
>Is there a documenting tool for tables on SQL Server 2000?
Look up Information_schema in BOL.
Also various sp_help SPs, like sp_helpindex.
J.
|||On Fri, 12 Aug 2005 04:18:12 -0700, "Chris"
<Chris@.discussions.microsoft.com> wrote:
>Is there a documenting tool for tables on SQL Server 2000?
Also, the diagrams facility in Enterprise Manager!
J.
|||Hi,
All the extended properties will be stored in "sysproperties" system table
of each database.
Eg:
CREATE table test (id int , name char (20))
go
EXEC sp_addextendedproperty 'caption', 'Employee ID', 'user', dbo,
'table', 'test', 'column', id
go
EXEC sp_addextendedproperty 'caption', 'Employee Name', 'user', dbo,
'table', 'test', 'column', name
go
select * from sysproperties where object_name(id)='test'
Instead of querying the system tables use the below code using functions to
get the extended properties,
SELECT * FROM ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table',
'test', 'column', default)
APEXSQL had got a very good tool for documentation.
http://www.apexsql.com/sql_tools_doc.asp
Thanks
Hari
SQL Server MVP
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:77FFE09C-F395-4FCD-B1C6-A643070103B7@.microsoft.com...
> Is there a documenting tool for tables on SQL Server 2000?
|||Hello,
I've created a free tool for this. You can find it at
http://sydi.sourceforge.net, it can create documentation in MS Word and XML.
The tool for SQL is SYDI-SQL, on the page there are also tools for
documenting Windows servers and MS Exchange.
Best regards
Patrick Ogenstad
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ugvQXg2nFHA.1996@.TK2MSFTNGP10.phx.gbl...
> Hi,
> All the extended properties will be stored in "sysproperties" system table
> of each database.
> Eg:
> CREATE table test (id int , name char (20))
> go
> EXEC sp_addextendedproperty 'caption', 'Employee ID', 'user', dbo,
> 'table', 'test', 'column', id
> go
> EXEC sp_addextendedproperty 'caption', 'Employee Name', 'user', dbo,
> 'table', 'test', 'column', name
> go
> select * from sysproperties where object_name(id)='test'
>
> Instead of querying the system tables use the below code using functions
to
> get the extended properties,
>
> SELECT * FROM ::fn_listextendedproperty (NULL, 'user', 'dbo',
'table',
> 'test', 'column', default)
>
> APEXSQL had got a very good tool for documentation.
>
> http://www.apexsql.com/sql_tools_doc.asp
>
> Thanks
> Hari
> SQL Server MVP
>
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:77FFE09C-F395-4FCD-B1C6-A643070103B7@.microsoft.com...
>

Documenting SQL Tables

Is there a documenting tool for tables on SQL Server 2000?Depends a bit on what documenting you intend to do....
Visio has a option to "reverse engineer" a database, but I'm not sure if
that's what you mean...?
Lee-Z
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:77FFE09C-F395-4FCD-B1C6-A643070103B7@.microsoft.com...
> Is there a documenting tool for tables on SQL Server 2000?|||I need to document the "Table Name", "Column Name", "Data Type", "Size",
"Lee-Z" wrote:

> Depends a bit on what documenting you intend to do....
> visio has a option to "reverse engineer" a database, but I'm not sure if
> that's what you mean...?
> Lee-Z
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:77FFE09C-F395-4FCD-B1C6-A643070103B7@.microsoft.com...
>
>|||Try something like
select a.name [Table],
b.name [Column],
b.xusertype [Type],
b.length [Length]
from sysobjects a joine syscolumns b on b.id=a.id
order by a.name,b.colorder, b.name
Or you could generate a SQL script for the DDL in the 'All Tasks' path
through enterprise manager.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Chris" wrote:
[vbcol=seagreen]
> I need to document the "Table Name", "Column Name", "Data Type", "Size",
> "Lee-Z" wrote:
>|||On Fri, 12 Aug 2005 04:18:12 -0700, "Chris"
<Chris@.discussions.microsoft.com> wrote:
>Is there a documenting tool for tables on SQL Server 2000?
Look up Information_schema in BOL.
Also various sp_help SPs, like sp_helpindex.
J.|||On Fri, 12 Aug 2005 04:18:12 -0700, "Chris"
<Chris@.discussions.microsoft.com> wrote:
>Is there a documenting tool for tables on SQL Server 2000?
Also, the diagrams facility in Enterprise Manager!
J.|||Hi,
All the extended properties will be stored in "sysproperties" system table
of each database.
Eg:
CREATE table test (id int , name char (20))
go
EXEC sp_addextendedproperty 'caption', 'Employee ID', 'user', dbo,
'table', 'test', 'column', id
go
EXEC sp_addextendedproperty 'caption', 'Employee Name', 'user', dbo,
'table', 'test', 'column', name
go
select * from sysproperties where object_name(id)='test'
Instead of querying the system tables use the below code using functions to
get the extended properties,
SELECT * FROM ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table',
'test', 'column', default)
APEXSQL had got a very good tool for documentation.
http://www.apexsql.com/sql_tools_doc.asp
Thanks
Hari
SQL Server MVP
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:77FFE09C-F395-4FCD-B1C6-A643070103B7@.microsoft.com...
> Is there a documenting tool for tables on SQL Server 2000?|||Hello,
I've created a free tool for this. You can find it at
http://sydi.sourceforge.net, it can create documentation in MS Word and XML.
The tool for SQL is SYDI-SQL, on the page there are also tools for
documenting Windows servers and MS Exchange.
Best regards
Patrick Ogenstad
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ugvQXg2nFHA.1996@.TK2MSFTNGP10.phx.gbl...
> Hi,
> All the extended properties will be stored in "sysproperties" system table
> of each database.
> Eg:
> CREATE table test (id int , name char (20))
> go
> EXEC sp_addextendedproperty 'caption', 'Employee ID', 'user', dbo,
> 'table', 'test', 'column', id
> go
> EXEC sp_addextendedproperty 'caption', 'Employee Name', 'user', dbo,
> 'table', 'test', 'column', name
> go
> select * from sysproperties where object_name(id)='test'
>
> Instead of querying the system tables use the below code using functions
to
> get the extended properties,
>
> SELECT * FROM ::fn_listextendedproperty (NULL, 'user', 'dbo',
'table',
> 'test', 'column', default)
>
> APEXSQL had got a very good tool for documentation.
>
> http://www.apexsql.com/sql_tools_doc.asp
>
> Thanks
> Hari
> SQL Server MVP
>
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:77FFE09C-F395-4FCD-B1C6-A643070103B7@.microsoft.com...
>

Documenting and searching a schema

Hi experts,
is there any external tool or feature within SQL Server 2005, which
enables a searchable documentation of schemas?
What I would like to do is to add descriptions to tables, columns and
foreign key relations describing their meaning in detail. By the term
"description" I do not mean a meaningful name, but (where required) a
longer, formatted text. Additional a google-like keyword search would
be nice, to be able to find matching elements, like e.g. all tables or
columns containing "customer" in the description text. The list of
search results should list the matching elements and show the first
few words of the description (very similar to the way google lists its
search results). If an element from the list is choosen, then the full
description should become visible. If the found elements could then be
dragged and dropped directly to a query builder - that would be
perfect!
As I don't think that I'm the first one thinking about enabling
documentation and search on database schemas, there should be tools
already existing for that purpose. But as I don't know any of them -
could you please suggest me some?
Kind regards,
Max
(send.me.all.email@.googlemail.com) writes:
> is there any external tool or feature within SQL Server 2005, which
> enables a searchable documentation of schemas?
> What I would like to do is to add descriptions to tables, columns and
> foreign key relations describing their meaning in detail. By the term
> "description" I do not mean a meaningful name, but (where required) a
> longer, formatted text. Additional a google-like keyword search would
> be nice, to be able to find matching elements, like e.g. all tables or
> columns containing "customer" in the description text. The list of
> search results should list the matching elements and show the first
> few words of the description (very similar to the way google lists its
> search results). If an element from the list is choosen, then the full
> description should become visible. If the found elements could then be
> dragged and dropped directly to a query builder - that would be
> perfect!
> As I don't think that I'm the first one thinking about enabling
> documentation and search on database schemas, there should be tools
> already existing for that purpose. But as I don't know any of them -
> could you please suggest me some?
You could look into SQLDoc from Red Gate (http://www.red-gate.com/). The
tool permits you to enter extended properties per table (not on column
level), and you can then generate a web site or HTML Help from the database.
Since HTML Help is searchable, this may be what you are looking for. You
can download a 14-day eval to have a look.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||Get a copy of Doc from ApexSQL (www.apexsql.com).
TheSQLGuru
President
Indicium Resources, Inc.
<send.me.all.email@.googlemail.com> wrote in message
news:1184095671.151380.170660@.o61g2000hsh.googlegr oups.com...
> Hi experts,
> is there any external tool or feature within SQL Server 2005, which
> enables a searchable documentation of schemas?
> What I would like to do is to add descriptions to tables, columns and
> foreign key relations describing their meaning in detail. By the term
> "description" I do not mean a meaningful name, but (where required) a
> longer, formatted text. Additional a google-like keyword search would
> be nice, to be able to find matching elements, like e.g. all tables or
> columns containing "customer" in the description text. The list of
> search results should list the matching elements and show the first
> few words of the description (very similar to the way google lists its
> search results). If an element from the list is choosen, then the full
> description should become visible. If the found elements could then be
> dragged and dropped directly to a query builder - that would be
> perfect!
> As I don't think that I'm the first one thinking about enabling
> documentation and search on database schemas, there should be tools
> already existing for that purpose. But as I don't know any of them -
> could you please suggest me some?
> Kind regards,
> Max
>

Documenting a reporting services site

Does anyone know of a good tool that will help with documenting a reporting services website? I inherited a prebuilt site and I am trying create some documentation about it. I have tried Visio, but it documents down to layers I do not need to go to. I just need the folder heirarchy and the reoprts within each folder.

Thanks for you help!

frank

Sorry - we don't have such a tool in the box. You can use a script to do this pretty easily. Create a VB.Net based script to call the ListChildren API recursively. Run it in rs.exe. You can format the output into a tree pattern to make it presentable.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||do you know if this is something that is possibly going to be in the "tool box" at a later date?|||

Not right now - we're working on our plans for what's coming in the future. This doesn't look like it will make it for the next release.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||Give RS Scripter a try.
http://www.sqldbatips.com/samples/code/RSScripter/readme.htm#_installing_rss
Once they're on your local machine, you can go to the command line and do a dir /b /s > list.txt to get a list of files by directory.
The information is also stored in the ReportServer database.

Documentation Tool

I was wondering if anyone has a good SQL Server Documentation tool. I have been looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone know of others?
Thanks for the help,
RDA
http://www.aspfaq.com/2209
http://www.aspfaq.com/
(Reverse address to reply.)
"RDA" <anonymous@.discussions.microsoft.com> wrote in message
news:48620959-3C4E-4520-A9B0-CAD19CE70530@.microsoft.com...
> I was wondering if anyone has a good SQL Server Documentation tool. I have
been looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone
know of others?
> Thanks for the help,
> RDA
|||RDA,
I like ER/Studio from Embarcadero.
http://www.embarcadero.com/products/erstudio/index.html
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
RDA wrote:
> I was wondering if anyone has a good SQL Server Documentation tool. I have been looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone know of others?
> Thanks for the help,
> RDA
|||Consider WT3 - one of the SQL Server Tools applications...
http://www.sqlservertools.us
It may do what you are asking for, as well as a lot more.

Documentation Tool

I was wondering if anyone has a good SQL Server Documentation tool. I have been looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone know of others
Thanks for the help
RDAhttp://www.aspfaq.com/2209
--
http://www.aspfaq.com/
(Reverse address to reply.)
"RDA" <anonymous@.discussions.microsoft.com> wrote in message
news:48620959-3C4E-4520-A9B0-CAD19CE70530@.microsoft.com...
> I was wondering if anyone has a good SQL Server Documentation tool. I have
been looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone
know of others?
> Thanks for the help,
> RDA|||RDA,
I like ER/Studio from Embarcadero.
http://www.embarcadero.com/products/erstudio/index.html
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
RDA wrote:
> I was wondering if anyone has a good SQL Server Documentation tool. I have been looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone know of others?
> Thanks for the help,
> RDA|||Consider WT3 - one of the SQL Server Tools applications..
http://www.sqlservertools.u
It may do what you are asking for, as well as a lot more

Documentation Tool

I was wondering if anyone has a good SQL Server Documentation tool. I have b
een looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone kn
ow of others?
Thanks for the help,
RDAhttp://www.aspfaq.com/2209
http://www.aspfaq.com/
(Reverse address to reply.)
"RDA" <anonymous@.discussions.microsoft.com> wrote in message
news:48620959-3C4E-4520-A9B0-CAD19CE70530@.microsoft.com...
> I was wondering if anyone has a good SQL Server Documentation tool. I have
been looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone
know of others?
> Thanks for the help,
> RDA|||RDA,
I like ER/Studio from Embarcadero.
http://www.embarcadero.com/products/erstudio/index.html
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
RDA wrote:
> I was wondering if anyone has a good SQL Server Documentation tool. I have
been looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone
know of others?
> Thanks for the help,
> RDA|||Consider WT3 - one of the SQL Server Tools applications...
http://www.sqlservertools.us
It may do what you are asking for, as well as a lot more.

Documentation

Hello,

I have a BI solution in SQL server 2005, is there a documentation tool to help me do the documentation for my project?

I use SSIS, SSAS and SSRS. I need documentation for the first two.

Thank you

http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/ssisvcs.mspx - SSIS

http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/ssasvcs.mspx - SSAS

http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/rptsvcs.mspx - SSRS

And SQL server 2005 books online too (updated Fe2007).

|||

Sorry, i must have explained wrongly.

I want to generate my solutions documentation, is there a way to do it using sql server 2005, or do i need a external tool?

If so, what tool?

Thanks

documentation

hello everyone,
I have to document about four databases, has anyone got any specific format or tool for documenting a database?
Any inputs would be very helpful
regards,
Harshal.I've used this tool (http://www.sql-server-performance.com/total_sql_analyzer.asp) earlier.|||Originally posted by Satya
I've used this tool (http://www.sql-server-performance.com/total_sql_analyzer.asp) earlier.

thanks for the quick reply,
but I have to write in details about the use of the table and the logic used in the stored procs also.
I'll go thru the software, is there any specific format for documenting?

Regards,
Harshal.|||I think with the help of VISIO also you can accomplish the task.
As of I know there is no specific format as such, it depends how easy you document.|||Originally posted by Satya
As of I know there is no specific format as such, it depends how easy you document.

yeah i guess it is so.

but really, documentation is third grade torture. :mad:|||Shame is no compatible tools available to document the database, rather we should depend upon third party supplied tools.:o|||Originally posted by Satya
Shame is no compatible tools available to document the database, rather we should depend upon third party supplied tools.:o

I beg to god for an :D intellegent tool :D which would also document all my procedures and their logic :D|||You will have to wait for next version of SQL Server after Yukon .. they might add it by then :)|||Documentation, is documentation.

It is painful.

If the code's not clean, it's even more painful.

Sorry...been there, done that.

PROC NAME:

Purpose:

Inputs:

Outputs:

Process flow:

And that's just the sprocs...

Do you need to a data model as well?

What about an application process model?

And what did you do wrong to get this assignment?|||documentation is already there, basic, maybe even primitive, but is there, in diagrams. if one was too lazy to write it as the app was being developed, doing it when everything else is done is going to be a project in itself. when this is the situation, you can use something as simple as copy con from dos prompt, or as sophisticated as robohelp office or er/studio or visio. the tool does not make any difference for as long as features of the tool will adequately describe what you got.|||Originally posted by Brett Kaiser
Documentation, is documentation.

It is painful.

If the code's not clean, it's even more painful.

Sorry...been there, done that.

PROC NAME:

Purpose:

Inputs:

Outputs:

Process flow:

And that's just the sprocs...

Do you need to a data model as well?

What about an application process model?

And what did you do wrong to get this assignment?

:rolleyes:

yeah the format is jsut similar to what i am currently using.
The real thing is in the process flow:mad: at places the code is worst this part is driving me crazy.
The application process model is to be documented by another guy :D
but yeah i do have to have the data flow diagrams :(

what i do wrong?
well that is a question i am been thinking of since yesterday
:D :p|||Well, in all honesty, walking in to a piece of sh-t system with no dco, is what a hired gun is all about.

If you can figure the sh-t out, you can do anything.

And yes, I always start with a data flow digram...

Gives a very clear picture of what's going on...

It's a higher level, but it gives you everything you need to then focus on the details...

Make sure that the diagram identifies the data, a process and the output of that process

There is no need to define the process in detail, just a descriptive name for a process...

It's a good way to define a road map to attack the details...

The devil is, as they say, in the details

That will come soon enough

But until you get a picture, it's a forect through the trees kinda thing

oh, and a big MOO|||Brett does diagrams...