Dan Waters
dwaters at usinternet.com
Fri Aug 14 19:11:59 CDT 2009
Mark, Your description of what I'm doing is perfect. Mostly I anticipate minor changes, but occasionally there will be a significant addition (I hope!). So, I'll probably do this by hand considering the tools you mentioned are at few hundred dollars each. After I write out code to make the changes I need, how do I deliver this to the DBA at my customer so that she can use it? Thanks! 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