|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
DB Change Deltas HELP!!!I know there are tools that can look at two different versions of a database
and generate a script to take one to match the other. I cannot seem to find anything suitable. I thought Visio could do this but I'm not seeing anything in the 2003 Pro version. We have major revisions that need to go live soon and I was hoping to find a tool to do this. THANK YOU!!!! For any hints you might have.... I use SQL Compare from www.red-gate.com just about every day. I can't count
how many hours it has saved me keeping various development versions of our database in sync. Show quote "Tim Greenwood" <tim_greenwood A-T yahoo D-O-T com> wrote in message news:urVBATHGGHA.984@tk2msftngp13.phx.gbl... >I know there are tools that can look at two different versions of a >database and generate a script to take one to match the other. I cannot >seem to find anything suitable. I thought Visio could do this but I'm not >seeing anything in the 2003 Pro version. > > We have major revisions that need to go live soon and I was hoping to find > a tool to do this. > > THANK YOU!!!! For any hints you might have.... > Are you wanting to comparing data or object schemas?
Using Enterprise Manager, you can generate scripts (one file per object and all scripting options enabled) for the two databases to different folders, and then do a file comparison using a tool like WinMerge. For example, if you made a change to a SP called usp_InvoiceDetailInsert, then WinMerge will highlight the file usp_InvoiceDetailInsert.PRC, and clicking on the file will highlight those lines that are different between them. The tool can also be configured to shell out to Query Analyzer (isqlw.exe) and execute the script. Also, most source control applications (like Visual Source Safe), will perform similar file comparisons between projects, if you are diligent enough to check in your database scripts. Show quote "Tim Greenwood" <tim_greenwood A-T yahoo D-O-T com> wrote in message news:urVBATHGGHA.984@tk2msftngp13.phx.gbl... >I know there are tools that can look at two different versions of a >database and generate a script to take one to match the other. I cannot >seem to find anything suitable. I thought Visio could do this but I'm not >seeing anything in the 2003 Pro version. > > We have major revisions that need to go live soon and I was hoping to find > a tool to do this. > > THANK YOU!!!! For any hints you might have.... > > I know there are tools that can look at two different versions of a Ours does, Database Workbench - www.upscene.comdatabase > and generate a script to take one to match the other. I cannot seem to find > anything suitable. I thought Visio could do this but I'm not seeing > anything in the 2003 Pro version. > > We have major revisions that need to go live soon and I was hoping to find a > tool to do this. Check the "Schema Compare" tool. -- Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com Thank you all for the suggestions....yes it is schema changes we are
tracking and it looks like the red-gate software is just what the doctor ordered, the DTS Compare tool looks like a good addition as well so the bundle is the way to go... Show quote "Tim Greenwood" <tim_greenwood A-T yahoo D-O-T com> wrote in message news:urVBATHGGHA.984@tk2msftngp13.phx.gbl... >I know there are tools that can look at two different versions of a >database and generate a script to take one to match the other. I cannot >seem to find anything suitable. I thought Visio could do this but I'm not >seeing anything in the 2003 Pro version. > > We have major revisions that need to go live soon and I was hoping to find > a tool to do this. > > THANK YOU!!!! For any hints you might have.... >  |
|||||||||||||||||||||||
Other interesting topics