Re: OT - Database schema compare/sync tools for MSSQL
On Thu, Apr 3, 2008 at 11:16 AM, Gerald Guido <[EMAIL PROTECTED]> wrote: > Does anyone know of a good tool that compares and/or syncs up Database > schema's for two tables/DBs. I want to grab fresh data off of production and > at the same time not have to manually update the schema for all the changes > I made. > > SQLYog for MySQL has a great tool that will generate the SQL to compare and > sync up the schema (and data FTM) for two tables/db's > > We are on 2005 standard. While you can't really go wrong with Red-Gate, as many people have recommended...I'd also take a look at Apex: http://www.apexsql.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303254 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT - Database schema compare/sync tools for MSSQL
+6 for Red Gate ... love it .. saves me a LOT of time .. as well as SQL Compare, for sync'ing db structures, there is Data compare that will sync the data. I've also used the command line interface, great for sync'ing multiple DBs without needing user interaction. -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: 03 April 2008 19:02 To: CF-Talk Subject: Re: OT - Database schema compare/sync tools for MSSQL Thank you for the help. G On Thu, Apr 3, 2008 at 12:01 PM, Brad Wood <[EMAIL PROTECTED]> wrote: > Red Gate rocks the hizzy. It also has an API you can tap into. We had > a previous SQL .net guy who wrote his own comparison tool using the > Regdate API's. > > ~Brad > > -Original Message- > From: Jeff Price [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 03, 2008 11:59 AM > To: CF-Talk > Subject: Re: OT - Database schema compare/sync tools for MSSQL > > +2 for Red Gate. > > -jeff > > >+1 for Red Gate's tools. > > > > > >-- > >Thanks, > > > >Tom > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303220 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT - Database schema compare/sync tools for MSSQL
Thank you for the help. G On Thu, Apr 3, 2008 at 12:01 PM, Brad Wood <[EMAIL PROTECTED]> wrote: > Red Gate rocks the hizzy. It also has an API you can tap into. We had > a previous SQL .net guy who wrote his own comparison tool using the > Regdate API's. > > ~Brad > > -Original Message- > From: Jeff Price [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 03, 2008 11:59 AM > To: CF-Talk > Subject: Re: OT - Database schema compare/sync tools for MSSQL > > +2 for Red Gate. > > -jeff > > >+1 for Red Gate's tools. > > > > > >-- > >Thanks, > > > >Tom > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302648 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT - Database schema compare/sync tools for MSSQL
Red Gate rocks the hizzy. It also has an API you can tap into. We had a previous SQL .net guy who wrote his own comparison tool using the Regdate API's. ~Brad -Original Message- From: Jeff Price [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2008 11:59 AM To: CF-Talk Subject: Re: OT - Database schema compare/sync tools for MSSQL +2 for Red Gate. -jeff >+1 for Red Gate's tools. > > >-- >Thanks, > >Tom ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302628 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT - Database schema compare/sync tools for MSSQL
+2 for Red Gate. -jeff >+1 for Red Gate's tools. > > >-- >Thanks, > >Tom ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302626 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT - Database schema compare/sync tools for MSSQL
+1 for Red Gate's tools. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302621 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT - Database schema compare/sync tools for MSSQL
Just started using some tools from http://www.red-gate.com/ So far so awesome! Adrian http://www.adrianlynch.co.uk/ -Original Message- From: Gerald Guido Sent: 03 April 2008 16:16 To: CF-Talk Subject: OT - Database schema compare/sync tools for MSSQL Does anyone know of a good tool that compares and/or syncs up Database schema's for two tables/DBs. I want to grab fresh data off of production and at the same time not have to manually update the schema for all the changes I made. SQLYog for MySQL has a great tool that will generate the SQL to compare and sync up the schema (and data FTM) for two tables/db's We are on 2005 standard. TIA G -- "Education is a progressive discovery of our own ignorance." - Will Durant ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302616 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT - Database schema compare/sync tools for MSSQL
Embarcadero's ER/Studio is great, but may be a bit pricy. m!ke -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2008 10:16 AM To: CF-Talk Subject: OT - Database schema compare/sync tools for MSSQL Does anyone know of a good tool that compares and/or syncs up Database schema's for two tables/DBs. I want to grab fresh data off of production and at the same time not have to manually update the schema for all the changes I made. SQLYog for MySQL has a great tool that will generate the SQL to compare and sync up the schema (and data FTM) for two tables/db's We are on 2005 standard. TIA G ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302612 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT - Database schema compare/sync tools for MSSQL
Does anyone know of a good tool that compares and/or syncs up Database schema's for two tables/DBs. I want to grab fresh data off of production and at the same time not have to manually update the schema for all the changes I made. SQLYog for MySQL has a great tool that will generate the SQL to compare and sync up the schema (and data FTM) for two tables/db's We are on 2005 standard. TIA G -- "Education is a progressive discovery of our own ignorance." - Will Durant ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302610 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4