I love powerdesigner :) at the moment I use dezign for databases - it's brilliant, quick and very easy to use. Good for reverse engineering existing dbs into diagrams as well, and can generate scripts for most dbs.
Toby On 18/10/2007, at 13:48 , Scott Thornton wrote: > > 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 > > > > > > > > ----------------------------------- 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 cfaussie@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---