Re: Maintain production DB with changes from development DB

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 04/09/04 

Date: Fri, 9 Apr 2004 17:08:11 +0100

I would be using a tool like Red Gate's SQL Compare. (Check the script
created though)

DTS will not update structure, it simply blows it away and replaces.

When you apply changes in your dev environments do you not keep the ALTER
scripts ? 

-- 
-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"George Prado" <anonymous@discussions.microsoft.com> wrote in message
news:CFDFD3FD-611D-49EC-B0F5-FD30BFF10B76@microsoft.com...
> I have about 4 production SQL servers all with the same DB structure.  Now
I need to update them with changes done to my development server.  What is
the best way to update all four servers?  Can DTS update the structure?  Or
will I have to write a script to update all 4 servers?  Any help would be
greatly appreciated.

Relevant Pages

  • Re: SQL Security
    ... except I'm having problems making it work in a script. ... ;Set properties of DB objects and open connection to database ... > from Books Online (within the SQL Server program group): ... > communicate with SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: ActiveX script works in DTS but not in job, why?
    ... Account that SQL Agent runs under and it is a Local Admin on the box. ... As another test I saved the script as a .vbs file and tried running it, ... Microsoft OLE DB Provider for SQL Server ... that would be since I need to be able to load DTS packages from either a SQL ...
    (microsoft.public.sqlserver.dts)
  • Re: How to DTS SQL Files to update Procs?
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... You would script>> them out to text file, change the CREATE to ALTER and then replay the file>> using OSQL ... >>> procs in one step via DTS. ...
    (microsoft.public.sqlserver.dts)
  • Re: DTSRun and Batch file
    ... >> install the DTS DLLs on the local machine. ... So the DTS package is running ... >> user to start a SQL Agent Job that runs the package. ... Darren Green (SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: How do I run a .BAS file saved from a DTS package?
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... I have used DTS for import and export. ... > The DTS Designer is easy to understand and use. ...
    (microsoft.public.sqlserver.dts)
Loading