Mark Breen
marklbreen at gmail.com
Fri Aug 14 18:10:33 CDT 2009
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 > >