Database Setup Tool

I was wondering if Microsoft SQL server has any tools that will will generate a setup.exe file to install the database on a seperate SQL server. I can see that you can script the entire database however it does not detect the dependencies in the correct order and hence I have to manually go through the script file and modify the creation order manually.

If we can generate a setup file

1) Network Admins who are installing the application and who have no idea of user SQL server can easily set up the database

2) I dont need to show the code for the sp, views etc as we can encrypt the code (I know it can be decrypted but that is ok)

I found tools from other vendors which we have to purchase to achive this.... Does MS Sql server have such a utility or is there any free utility that does this?

i guess u need to transfer database from one server to another. if this is the requirement , there are two methods

(a) Backup /restore

(b) detach/attach

You can automate it. If you have tried this pse let us know what is the difficulties u faced. Scripting database is not a complete solution.

pse refer BOL or post back if you are not clear with these terms

Madhu

|||

thanks Madhu.

But i only want to transfer the database structure ... not the data within it. If I do a backup / restore or detach / attach, it will take the data + transaction logs along with it. I can script the data + transaction logs to be cleared before doing the backup. But I dont want the data to be cleared in my environment as it has a lot of test data that has taken months to do. Alternatively i have to take another backup before clearing the data.

All this is going to be untidy. So that is why I was looking for a setup utility as I have seen other applications do this.

|||

if you asked the tool available ... then the answer may be Visio. Visio can easily handle these kind of scenario. As such there should not be any problem in Scripting from SQL Server also. Could you please tell us what is the problem u faced when u script the object using Management stuido and runing it in target server.

Redgate and all have tools for these kind of activities. But i strongly feel that SQL Server inbuilt features can easily handle this issue.

Also post back the result of Select @.@.version .

Madhu

Database Schema Documentation Tool?

I am looking for a database documentation tool/script that I can run against
a particular database to generate a document of all the tables, columns, and
relationships in the database. I have seen a data dictionary that lists the
table names with links to the table details further down the document, and
clicking on the relationships jumps you to that table in the document. That
particular one was generated out of the programming revision control system
they were using into xml and xsl files. I am looking for something that can
generate the information out of the metadata in SQL Server.
Thanks
I think you may be thinking of Enterprise Architect
http://www.sparxsystems.com.au/
Or ER/Studio
http://www.embarcadero.com/products/erstudio/index.html
"Greg Hess" <keadrix@.hotmail.com> wrote in message
news:uiaR8UcFHHA.1252@.TK2MSFTNGP02.phx.gbl...
>I am looking for a database documentation tool/script that I can run
>against a particular database to generate a document of all the tables,
>columns, and relationships in the database. I have seen a data dictionary
>that lists the table names with links to the table details further down the
>document, and clicking on the relationships jumps you to that table in the
>document. That particular one was generated out of the programming
>revision control system they were using into xml and xsl files. I am
>looking for something that can generate the information out of the metadata
>in SQL Server.
> Thanks
>
|||Look at ApexSQL Doc from www.ApexSQL.com
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Greg Hess" <keadrix@.hotmail.com> wrote in message
news:uiaR8UcFHHA.1252@.TK2MSFTNGP02.phx.gbl...
>I am looking for a database documentation tool/script that I can run
>against a particular database to generate a document of all the tables,
>columns, and relationships in the database. I have seen a data dictionary
>that lists the table names with links to the table details further down the
>document, and clicking on the relationships jumps you to that table in the
>document. That particular one was generated out of the programming
>revision control system they were using into xml and xsl files. I am
>looking for something that can generate the information out of the metadata
>in SQL Server.
> Thanks
>
|||I love ApexSQL . See the details from below URL:-
http://www.sql-server-performance.com/apex_sql_doc_spotlight.asp
http://www.apexsql.com/sql_tools_doc.asp
You could try the trial version and use it for a month:-
http://www.apexsql.com/downloads.asp
Thanks
Hari
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:OyNRBReFHHA.4712@.TK2MSFTNGP04.phx.gbl...
> Look at ApexSQL Doc from www.ApexSQL.com
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "Greg Hess" <keadrix@.hotmail.com> wrote in message
> news:uiaR8UcFHHA.1252@.TK2MSFTNGP02.phx.gbl...
>
|||Another effective but much less costly option if you only want
documentation is
SqlSpec from ElsaSoft
Their website at www.elsasoft.org has a trial version and also samples
of the output
T
|||Greg Hess wrote:
> I am looking for a database documentation tool/script that I can run against
> a particular database to generate a document of all the tables, columns, and
> relationships in the database. I have seen a data dictionary that lists the
> table names with links to the table details further down the document, and
> clicking on the relationships jumps you to that table in the document. That
> particular one was generated out of the programming revision control system
> they were using into xml and xsl files. I am looking for something that can
> generate the information out of the metadata in SQL Server.
> Thanks
You might want to try SchemaToDoc for SQL Server
(http://www.schematodoc.com). It exports to a Word doc metadata info
such as primary keys, field info (types, size, nullable, defaults),
indexes, check constraints, foreign key constraints, triggers, views,
stored procedures, and extended properties. It also lets you annotate
your tables and fields and include those comments in the Word doc. An
Enterprise edition can create a series of linked HTML files in addition
to the Word output.
|||Thank you for all your suggestions. After evaluating them I have decided to
go with SqlSpec from Elsasoft (http://www.elsasoft.org/). It does exactly
what I need it to do for a good price.

Database performance improvement

People:

I work with IBM DB2 and there is a tool called REORGCHK and REORG.

It is used to eveluate the status of tables and indexes(REORGCHK) and in case we run the REORG to fix any fragmentation problem in tables and indexes...

The question is Is there something similar in SQL Server?

I have deleted lots of records and looks like after that the performance of the database is not very good.

Thankswhat version of SQLserver?

Sounds like a rebuild of the index may be needed, it can't hurt to rebuild
after a large delete.

At a low level you could run
DBCC INDEXDEFRAG

Via Enterprise (SQLserver 2000) you can create a maintenance plan to cleanup space and indexes. Just run the wizard to create the optimisation job and run it straight away.

Have Fun|||I have SQL 2000 Server.
Can I run the dbcc command during the day??|||Hi,

If you using SQLserver 2000, the easiest solution is to create a maintenance plan to do this periodically eg once per week.

In Enterprise Manager choose the database -> management
right click on database maintenance plans -> choose new plan

Follow the wizard to create an optimisation maintenance plan.

I tend to create a plan for optimisation and integrity checking and a separate one for back of database / logs.

If your database is really under the weather running the DBCC (or a maintenance doing the same thing) would the highest priority. So running during the day is justified.

Have Fun