Re: Managing Databases on Multiple Servers

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "KLDBA" <KLMADDBA@xxxxxxxxx>
Date: 14 Nov 2006 00:12:07 -0800

try the following command and it really make our dba life easy.

osql.exe + your_update_script.sql

Paul

rgagne99@xxxxxxxxx wrote:

I need to deploy a database fix (sql DDL Script) to many databases on
many servers. All databases are identical in structure. I just need
to play the hotfix script on all of the DBs.

I don't want to open a seperate window for each DB in Stidio. What
mechanisms are available to do this automatically? Are people using
ISQL for this? DTS? SSIS? Thrid party packages?

What are people doing out there to maintain DBs in many locations?

Is there a bette group for me to post this message?

...Ray

References:
- Managing Databases on Multiple Servers
  - From: rgagne99

Prev by Date: Re: try catch ok, what about finally?
Next by Date: DB data and log filenames
Previous by thread: Re: Managing Databases on Multiple Servers
Next by thread: DB data and log filenames
Index(es):
- Date
- Thread

Relevant Pages

Re: Query Two Databases
... > Depends on the databases. ... If the 2 DBs are MS SQL Server DBs on the ... > same server you can do a query like this: ...
(microsoft.public.access.queries)
Re: Stack out of space problem
... Akash, this seems to be more of a VB related issue. ... > I am facing one problem on my client loactions Please ... > seprated Dbs and installed on the same SQl 2000 server. ... > SQL 2000 servers. ...
(microsoft.public.sqlserver.programming)
Re: Out of stack space
... > I am facing one problem on my client loactions Please ... > seprated Dbs and installed on the same SQl 2000 server. ... > SQL 2000 servers. ... > This error is comming only while opening few forms. ...
(microsoft.public.vb.database.ado)
Re: Query Two Databases
... If the 2 DBs are MS SQL Server DBs on the ... FROM databaseA..table1 AS A INNER JOIN dtabaseB..table1 AS B ... Or must I create a linked-table reference in one of the databases? ...
(microsoft.public.access.queries)
Re: Performance issue
... I concur with Mike and also would like to add a note about dependencies/relations and backup. ... Too often I see applications split over several databases where the developers didn't even consider ... > The only reason that I can think of for splitting the tables across multiple ... > move DBs between servers (I encountered big headaches migrating SQL6.5 DBs ...
(microsoft.public.sqlserver.server)