Hey Toby, last week you asked for a tool to compare schemas and generate DDL. Do you mean generic schemas (not yet defined as databases), or you do you mean that term to refer to the schema as defined in SQL Server? In addition to the tool Ryan mentioned, I'll point out a couple others.
One is among a set of tools I blogged about a couple od weeks ago: Free Tool Friday: Several free enterprise-class tools from Adventnet / ManageEngine http://carehart.org/blog/client/index.cfm/2007/10/12/free_tool_friday_manage engine The SQL compare tool is called SwisSQL DBChangeManager 4: http://www.swissql.com/products/database-compare-synchronize-tool/index.html There is a link to the free edition (which explains its limits) at the top right of that page. Other such tools include RedGate SQL Compare: http://www.red-gate.com/products/SQL_Compare/index.htm. It's not free, though. If you need still more choices for your needs, I see a list of what seems to be many pages of such tools, at http://compare-sql.qarchive.org. /charlie -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Wednesday, October 17, 2007 11:49 PM To: [email protected] Subject: [cfaussie] Anyone using SQL Delta? Toby, Can you name a product that creates and compares schemas and generates DDL? I use an old version of powerdesigner but I'd like to know what else is out there. >>> Toby Tremayne <[EMAIL PROTECTED]> 18/10/2007 1:23 pm >>> I've used it a couple of times - fantastic product for managing changes during dev cycles to a live database. Generally I like to base everything from a schema diagram in a db that can generate scripts - some of these products can handle making changes / additions directly in the db, but when you don't have one of those, sqldelta can be very handy. Toby On 18/10/2007, at 12:18 , Ryan Sabir wrote: > Hi all, > > For those following the recent thread about SQL Server 2005 database > transfering woes... > > We've just discovered this great tool: http://www.sqldelta.com/ > > You point it at 2 databases and it will tell you the difference > between them, and then creates scripts that synchronise the schema and > data between the 2. > > Just wondering if anyone has used it extensively and can vouch for its > reliability? We tried it one a fairly large database and it seemed to > run fine... has anyone had any good or bad experiences with it? > > thanks. > > > Ryan Sabir > Technical Director > > p: (02) 9274 8030 > f: (02) 9274 8099 > m: 0411 512 454 > w: www.newgency.com Newgency Pty Ltd > Web | Multimedia | eMarketing > > 115 Cooper St > Surry Hills NSW 2010 > Sydney, Australia > > > > ----------------------------------- Life is poetry, write it in your own words ----------------------------------- Toby Tremayne Senior Technical Consultant Code Poet and Zen Master of the Heavy Sleep Lyricist Software 0416 048 090 ICQ: 13107913 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
