|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Version Control SQL2k?I didn't know where else to post this question so forgive me if this
is the wrong place. I'm looking for a tool/tools to help with schema changes in SQL 2000. I was wondering if I could get the groups experiences with various tools. Here are a few I am looking at We are not using VSS or SQL 2005 yet, so I am not looking at those for Options. Quest Change Director SwisSQL DataChangeManager RedGate SqlCompare PCWIN SQLDBCompare TIA! David Hay You don't say what kind of changes you are looking for help on. You don't
need any tools to make changes to the database other than Enterprise Manager or Query Analyzer. So what exactly do you need these tools to do for you? -- Show quoteAndrew J. Kelly SQL MVP Solid Quality Mentors "David Hay" <david.***@gmail.com> wrote in message news:1191872439.599240.326790@57g2000hsv.googlegroups.com... >I didn't know where else to post this question so forgive me if this > is the wrong place. I'm looking for a tool/tools to help with schema > changes in SQL 2000. I was wondering if I could get the groups > experiences with various tools. Here are a few I am looking at > > We are not using VSS or SQL 2005 yet, so I am not looking at those for > Options. > > Quest Change Director > SwisSQL DataChangeManager > RedGate SqlCompare > PCWIN SQLDBCompare > > > TIA! > > David Hay > Sorry about that. I am looking for something that will help with
version control, and moving Schema changes across servers that can have some sort of audit trail, and the ability to roll back changes if need be. Thanks! David Hay Show quote On Oct 8, 6:20 pm, "Andrew J. Kelly" <sqlmvpnooos***@shadhawk.com> wrote: > You don't say what kind of changes you are looking for help on. You don't > need any tools to make changes to the database other than Enterprise Manager > or Query Analyzer. So what exactly do you need these tools to do for you? > > -- > Andrew J. Kelly SQL MVP > Solid Quality Mentors > David,
Well SQL Compare from Red-Gate ( www.red-gate.com) does an excellent job at comparing dbs and generating scripts. You can use the scripts with source control as well. DBGhost (http://www.dbghost.com/) claims better source control features but I haven't used it so I can't say any more than that. Both will generate scripts that can be rolled back. -- Show quoteAndrew J. Kelly SQL MVP Solid Quality Mentors "David Hay" <david.***@gmail.com> wrote in message news:1191930355.914394.16330@v3g2000hsg.googlegroups.com... > Sorry about that. I am looking for something that will help with > version control, and moving Schema changes across servers that can > have some sort of audit trail, and the ability to roll back changes if > need be. > > Thanks! > > David Hay > > On Oct 8, 6:20 pm, "Andrew J. Kelly" <sqlmvpnooos***@shadhawk.com> > wrote: >> You don't say what kind of changes you are looking for help on. You don't >> need any tools to make changes to the database other than Enterprise >> Manager >> or Query Analyzer. So what exactly do you need these tools to do for >> you? >> >> -- >> Andrew J. Kelly SQL MVP >> Solid Quality Mentors >> >  |
|||||||||||||||||||||||
Other interesting topics