Deployment Scripts

We are introducing a new infrastructure in work where we use depoyment
scripts rather than tweaking the db with Enterprise Manager. While I can see
the benefits of this it will be time consuming. Are there any tools out
there to automatically generate any kind of DDL script you would want. For
instance I can't find a way in Enterprise Manager/ Query Analyser to
generate logins or stuff related to jobs. Regards, Chris.Chris,
to generate logins, there is the Options tab on the Generate SQL Scripts
dialogue. For jobs, just highlight them all and right-click.
There are other things that aren't scriptable though from the GUI (linked
servers, maintenance plans, diagrams etc). For these I know of workarounds
but no simple tool. BTW in SQL Server 2005 almost anything is scriptable
from the GUI.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Chris wrote:
> We are introducing a new infrastructure in work where we use depoyment
> scripts rather than tweaking the db with Enterprise Manager. While I can s
ee
> the benefits of this it will be time consuming. Are there any tools out
> there to automatically generate any kind of DDL script you would want. For
> instance I can't find a way in Enterprise Manager/ Query Analyser to
> generate logins or stuff related to jobs. Regards, Chris.
>
Kudos to whoever is driving this change. It may seem time consuming
now, but after you get used to it, you'll find that the GUI is actually
harder to use than writing the scripts.
While some things may not be directly scriptable from Enterprise
Manager, virtually EVERYTHING that EM does can be done using scripts,
you just have to learn the commands. One way to observe what goes on
under the covers is to use Profiler to capture the commands issued by EM
when performing various operations.
Tracy McKibben
MCDBA
http://www.realsqlguy.comsql

Deployment Scripts

We are introducing a new infrastructure in work where we use depoyment
scripts rather than tweaking the db with Enterprise Manager. While I can see
the benefits of this it will be time consuming. Are there any tools out
there to automatically generate any kind of DDL script you would want. For
instance I can't find a way in Enterprise Manager/ Query Analyser to
generate logins or stuff related to jobs. Regards, Chris.Chris,
to generate logins, there is the Options tab on the Generate SQL Scripts
dialogue. For jobs, just highlight them all and right-click.
There are other things that aren't scriptable though from the GUI (linked
servers, maintenance plans, diagrams etc). For these I know of workarounds
but no simple tool. BTW in SQL Server 2005 almost anything is scriptable
from the GUI.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Chris wrote:
> We are introducing a new infrastructure in work where we use depoyment
> scripts rather than tweaking the db with Enterprise Manager. While I can see
> the benefits of this it will be time consuming. Are there any tools out
> there to automatically generate any kind of DDL script you would want. For
> instance I can't find a way in Enterprise Manager/ Query Analyser to
> generate logins or stuff related to jobs. Regards, Chris.
>
Kudos to whoever is driving this change. It may seem time consuming
now, but after you get used to it, you'll find that the GUI is actually
harder to use than writing the scripts.
While some things may not be directly scriptable from Enterprise
Manager, virtually EVERYTHING that EM does can be done using scripts,
you just have to learn the commands. One way to observe what goes on
under the covers is to use Profiler to capture the commands issued by EM
when performing various operations.
Tracy McKibben
MCDBA
http://www.realsqlguy.com

Deployment Questions

I am planning to install/deploy SQL Reporting Services at our agency.
We have a web server, a SQL Server (Enterprise license), and various
other servers. I know that the RS database has to be installed on a
server with SQL Server 2000 license, but is it also advisable to
install the report server components on the SQL Server box? This would
entail putting IIS on the SQL Server machine, and I'm not sure that
this is a good idea...
Basically, I am looking for "best practices" for a standard deployment
of RS. At this point, we will be running our application over our
local intranet, and will only have about 20 users.Hello Jad,
Just to note. Installing Reporting Services on the same server running SQL
Server 2000 is not a requirement. During Setup, you can choose whether to
create the report server database on a local or remote SQL Server instance.
Take a peek at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_8jom.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_8k82.asp
Adrian M.
"JAD" <jdevilli@.lasers.state.la.us> wrote in message
news:1106087493.051954.122790@.c13g2000cwb.googlegroups.com...
>I am planning to install/deploy SQL Reporting Services at our agency.
> We have a web server, a SQL Server (Enterprise license), and various
> other servers. I know that the RS database has to be installed on a
> server with SQL Server 2000 license, but is it also advisable to
> install the report server components on the SQL Server box? This would
> entail putting IIS on the SQL Server machine, and I'm not sure that
> this is a good idea...
> Basically, I am looking for "best practices" for a standard deployment
> of RS. At this point, we will be running our application over our
> local intranet, and will only have about 20 users.
>|||You can deploy reports just by right click on the project and select
deploying to the desired report server.
Or you can use scripts for deploying reports.
Another method is uploading the rdl on the report server.
The first one is easier but the developer should be an admin of the report
server.
Eralper
http://www.kodyaz.com
"JAD" wrote:
> I am planning to install/deploy SQL Reporting Services at our agency.
> We have a web server, a SQL Server (Enterprise license), and various
> other servers. I know that the RS database has to be installed on a
> server with SQL Server 2000 license, but is it also advisable to
> install the report server components on the SQL Server box? This would
> entail putting IIS on the SQL Server machine, and I'm not sure that
> this is a good idea...
> Basically, I am looking for "best practices" for a standard deployment
> of RS. At this point, we will be running our application over our
> local intranet, and will only have about 20 users.
>

Deploying SQL Express Throughout the Organization/Enterprise

What are some recommended methods for deploying SQL Express throughout an entire organization? It appears that Active Directory/GPO deployment is out of the equation.

Thanks,

Shane

hi Shane,

as SQLExpress is SQL Server, and as SQL Server is a service potentially serving lot's of user, SQLExpress is usually installed on a machine available through the whole lan.. all the clients connect to that instance and it answers to all the incoming requests... this is the "traditional" scenario of an enterprise wide database server...

what is your "problem"?

regards

|||

In our case SQL Express needs to be deployed to each PC because the product is used connected and disconnected to the network. Is there a documented or recommended method of deploying SQL Express to each PC?

Thanks,

Shane

|||

hi Shane,

a nice article has been written by Robert Walters including ClickOnce as well..

regards

|||

Andrea,

Thanks for the information. I have seen that article before and it is very good. We are using the ClickOnce bootstrapper but not actually using ClickOnce itself. What I am really looking for is recommendations on pushing SQL Express to PCs in an organization. Active Directory/GPO is commonly used for Windows Installer installations and while SQL Express is a Windows Installer installation under the hood it doesn't appear it would be practical and possibly not even possible to push it out this way. Is this a valid assessment? There are other electronic software delivery tools out there like SMS that may do the job, but we don't have experience with those tools. Would these tools be appropraite for pushing out SQL Express? Has anyone tried this successfully?

Thanks,

Shane

Dependencies

In Enterprise Manager (EM), how does it arrive at
the dependencies for a table?
The reason I am asking is, before I add additional
columns to a table, under "objects dependent on
<tablename>", it shows tables, procedures, triggers, etc.
After I add columns to this table, it shows only tables
but nothing else.
What could be the reason? What I may be doing wrong?
How can I relink everything?
Thank you,
Kelly
To learn what EM does, run a profiler trace. You will probably find that EM calls a number of stored
procedures. So, you can read the source code for those stored procedures to determine whether you should
consider this a bug and possibly open a case with MS Support.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kelly" <anonymous@.discussions.microsoft.com> wrote in message news:1cb6901c4532d$bcccab20$a301280a@.phx.gbl...
> In Enterprise Manager (EM), how does it arrive at
> the dependencies for a table?
> The reason I am asking is, before I add additional
> columns to a table, under "objects dependent on
> <tablename>", it shows tables, procedures, triggers, etc.
> After I add columns to this table, it shows only tables
> but nothing else.
> What could be the reason? What I may be doing wrong?
> How can I relink everything?
> Thank you,
> Kelly
|||Depending on the nature of the table changes EM may create a new table, copy the data, and drop the original table. This process causes the dependency records to be lost. The dependency records can be restored by dropping and creating all the dependent
objects in the proper sequence, or by...
Two of the SQL Server Tools applications have an option to restore dependency records automatically. WT2 and WT3 implement that feature in the same way, but then they diverge into different functionality. You can learn more at this URL...
http://www.sqlservertools.us
"Kelly" wrote:

> In Enterprise Manager (EM), how does it arrive at
> the dependencies for a table?
> The reason I am asking is, before I add additional
> columns to a table, under "objects dependent on
> <tablename>", it shows tables, procedures, triggers, etc.
> After I add columns to this table, it shows only tables
> but nothing else.
> What could be the reason? What I may be doing wrong?
> How can I relink everything?
> Thank you,
> Kelly
>
|||Tibor,
Thanks for your input.
-Kelly

>--Original Message--
>To learn what EM does, run a profiler trace. You will
probably find that EM calls a number of stored
>procedures. So, you can read the source code for those
stored procedures to determine whether you should
>consider this a bug and possibly open a case with MS
Support.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Kelly" <anonymous@.discussions.microsoft.com> wrote in
message news:1cb6901c4532d$bcccab20$a301280a@.phx.gbl...[vbcol=seagreen]
etc.
>
>.
>
|||Thanks for the information.
-Kelly
>--Original Message--
>Depending on the nature of the table changes EM may
create a new table, copy the data, and drop the original
table. This process causes the dependency records to be
lost. The dependency records can be restored by dropping
and creating all the dependent objects in the proper
sequence, or by...
>Two of the SQL Server Tools applications have an option
to restore dependency records automatically. WT2 and WT3
implement that feature in the same way, but then they
diverge into different functionality. You can learn more
at this URL...[vbcol=seagreen]
>http://www.sqlservertools.us
>"Kelly" wrote:
etc.
>.
>

Dependencies

In Enterprise Manager (EM), how does it arrive at
the dependencies for a table?
The reason I am asking is, before I add additional
columns to a table, under "objects dependent on
<tablename>", it shows tables, procedures, triggers, etc.
After I add columns to this table, it shows only tables
but nothing else.
What could be the reason? What I may be doing wrong?
How can I relink everything?
Thank you,
KellyTo learn what EM does, run a profiler trace. You will probably find that EM
calls a number of stored
procedures. So, you can read the source code for those stored procedures to
determine whether you should
consider this a bug and possibly open a case with MS Support.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kelly" <anonymous@.discussions.microsoft.com> wrote in message news:1cb6901c4532d$bcccab20$a
301280a@.phx.gbl...
> In Enterprise Manager (EM), how does it arrive at
> the dependencies for a table?
> The reason I am asking is, before I add additional
> columns to a table, under "objects dependent on
> <tablename>", it shows tables, procedures, triggers, etc.
> After I add columns to this table, it shows only tables
> but nothing else.
> What could be the reason? What I may be doing wrong?
> How can I relink everything?
> Thank you,
> Kelly|||Depending on the nature of the table changes EM may create a new table, copy
the data, and drop the original table. This process causes the dependency
records to be lost. The dependency records can be restored by dropping and
creating all the dependent
objects in the proper sequence, or by...
Two of the SQL Server Tools applications have an option to restore dependenc
y records automatically. WT2 and WT3 implement that feature in the same way
, but then they diverge into different functionality. You can learn more at
this URL...
http://www.sqlservertools.us
"Kelly" wrote:

> In Enterprise Manager (EM), how does it arrive at
> the dependencies for a table?
> The reason I am asking is, before I add additional
> columns to a table, under "objects dependent on
> <tablename>", it shows tables, procedures, triggers, etc.
> After I add columns to this table, it shows only tables
> but nothing else.
> What could be the reason? What I may be doing wrong?
> How can I relink everything?
> Thank you,
> Kelly
>|||Tibor,
Thanks for your input.
-Kelly

>--Original Message--
>To learn what EM does, run a profiler trace. You will
probably find that EM calls a number of stored
>procedures. So, you can read the source code for those
stored procedures to determine whether you should
>consider this a bug and possibly open a case with MS
Support.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Kelly" <anonymous@.discussions.microsoft.com> wrote in
message news:1cb6901c4532d$bcccab20$a301280a@.phx
.gbl...
etc.[vbcol=seagreen]
>
>.
>|||Thanks for the information.
-Kelly
>--Original Message--
>Depending on the nature of the table changes EM may
create a new table, copy the data, and drop the original
table. This process causes the dependency records to be
lost. The dependency records can be restored by dropping
and creating all the dependent objects in the proper
sequence, or by...
>Two of the SQL Server Tools applications have an option
to restore dependency records automatically. WT2 and WT3
implement that feature in the same way, but then they
diverge into different functionality. You can learn more
at this URL...
>http://www.sqlservertools.us
>"Kelly" wrote:
>
etc.[vbcol=seagreen]
>.
>

Dependencies

In Enterprise Manager (EM), how does it arrive at
the dependencies for a table?
The reason I am asking is, before I add additional
columns to a table, under "objects dependent on
<tablename>", it shows tables, procedures, triggers, etc.
After I add columns to this table, it shows only tables
but nothing else.
What could be the reason? What I may be doing wrong?
How can I relink everything?
Thank you,
KellyTo learn what EM does, run a profiler trace. You will probably find that EM calls a number of stored
procedures. So, you can read the source code for those stored procedures to determine whether you should
consider this a bug and possibly open a case with MS Support.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kelly" <anonymous@.discussions.microsoft.com> wrote in message news:1cb6901c4532d$bcccab20$a301280a@.phx.gbl...
> In Enterprise Manager (EM), how does it arrive at
> the dependencies for a table?
> The reason I am asking is, before I add additional
> columns to a table, under "objects dependent on
> <tablename>", it shows tables, procedures, triggers, etc.
> After I add columns to this table, it shows only tables
> but nothing else.
> What could be the reason? What I may be doing wrong?
> How can I relink everything?
> Thank you,
> Kelly|||Depending on the nature of the table changes EM may create a new table, copy the data, and drop the original table. This process causes the dependency records to be lost. The dependency records can be restored by dropping and creating all the dependent objects in the proper sequence, or by...
Two of the SQL Server Tools applications have an option to restore dependency records automatically. WT2 and WT3 implement that feature in the same way, but then they diverge into different functionality. You can learn more at this URL...
http://www.sqlservertools.us
"Kelly" wrote:
> In Enterprise Manager (EM), how does it arrive at
> the dependencies for a table?
> The reason I am asking is, before I add additional
> columns to a table, under "objects dependent on
> <tablename>", it shows tables, procedures, triggers, etc.
> After I add columns to this table, it shows only tables
> but nothing else.
> What could be the reason? What I may be doing wrong?
> How can I relink everything?
> Thank you,
> Kelly
>|||Tibor,
Thanks for your input.
-Kelly
>--Original Message--
>To learn what EM does, run a profiler trace. You will
probably find that EM calls a number of stored
>procedures. So, you can read the source code for those
stored procedures to determine whether you should
>consider this a bug and possibly open a case with MS
Support.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Kelly" <anonymous@.discussions.microsoft.com> wrote in
message news:1cb6901c4532d$bcccab20$a301280a@.phx.gbl...
>> In Enterprise Manager (EM), how does it arrive at
>> the dependencies for a table?
>> The reason I am asking is, before I add additional
>> columns to a table, under "objects dependent on
>> <tablename>", it shows tables, procedures, triggers,
etc.
>> After I add columns to this table, it shows only tables
>> but nothing else.
>> What could be the reason? What I may be doing wrong?
>> How can I relink everything?
>> Thank you,
>> Kelly
>
>.
>|||Thanks for the information.
-Kelly
>--Original Message--
>Depending on the nature of the table changes EM may
create a new table, copy the data, and drop the original
table. This process causes the dependency records to be
lost. The dependency records can be restored by dropping
and creating all the dependent objects in the proper
sequence, or by...
>Two of the SQL Server Tools applications have an option
to restore dependency records automatically. WT2 and WT3
implement that feature in the same way, but then they
diverge into different functionality. You can learn more
at this URL...
>http://www.sqlservertools.us
>"Kelly" wrote:
>> In Enterprise Manager (EM), how does it arrive at
>> the dependencies for a table?
>> The reason I am asking is, before I add additional
>> columns to a table, under "objects dependent on
>> <tablename>", it shows tables, procedures, triggers,
etc.
>> After I add columns to this table, it shows only tables
>> but nothing else.
>> What could be the reason? What I may be doing wrong?
>> How can I relink everything?
>> Thank you,
>> Kelly
>.
>