[dba-SQLServer] Creating an Update Package for SQL Server

Hello Dan,
I have not used the feature that you are describing although it sounds
convienent for some occasions.

However, the trial version of SQL Compare is free for the first 14 days. And
that might serve you well for the few times you need it.  You can always
install it on another machine if you need to do major updates again in the
future.

The nice thing about the comparison is that it allows you to really see the
differences in all tables, views sprocs and all other objects in the db.

Thanks for letting us know about the change scripts in VS2008.  I will have
to study that now.

Mark



2009/8/15 Dan Waters <dwaters at usinternet.com>

> Hi Mark,
>
> I have a copy of VS Studio 2008.  From the book, it looks like I will be
> able to automatically generate Change Scripts while making changes to a
> table.  Sounds like recording a macros in Excel.  Each script is stored as
> a
> file that I can then send to the DBA at my customer.
>
> Thanks again!
> Dan
>
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Mark
> Breen
> Sent: Friday, August 14, 2009 6:11 PM
> To: Discussion concerning MS SQL Server
> Subject: Re: [dba-SQLServer] Creating an Update Package for SQL Server
>
> Hello Dan,
> They are probably talking about you creating a script that Updates the old
> database with the changes that you have created on your development
> environment.
>
> There are a number of tools out there that do that for you, AdeptSQL and
> RedGate are two companies that produce tools to do that.
>
> Basically they allow you to point to the live server and the dev server and
> then they produce a single file with the scripts that you can run.
>
> the script can update one column in one table to creating hundreds of
> sprocs
> and tables.
>
> If you intend to just create minor changes then you will not need these,
> you
> many just write the SQL by hand.
>
> Have a look at the Edit menu option in SQL Server for a table, then add a
> column from design view.  Then look at edit again.  Note the differences
> for
> the new column.
>
> Then try writing the SQL yourself.
>
> It will be something like
>
> Alter tblCustomers add column WifesMobile nvarchar(50)
>
> it becomes trickier to do it by hand when you modify columns in that case,
> the tools are great.
>
> Does this answer your question?
>
> BTW, Redgate can be trialled for 14 days.
>
> Best of luck,
>
> Mark
>
>
>
> 2009/8/14 Dan Waters <dwaters at usinternet.com>
>
> > At one of my customers, we are upsizing to SQL Server.  Since I'm
> > connecting
> > with ODBC table links, it's not that big a deal.
> >
> > However, the instance of SS will be on a production server, which I won't
> > have access to.  But, I still need to make table design changes from time
> > to
> > time.  The IT folks there said that I can make an 'Update Package' to
> > accomplish this.  The idea is that I can make this Update Package as a
> > single file, which I can send to the DBA, and she can then 'run' the file
> > which will make all the changes.
> >
> > So, how do I begin to learn how to do this?
> >
> > Thanks!
> > Dan
> >
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
> >
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>