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

Embarcadero's ER/Studio is great, but may be a bit pricy. m!ke 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

Just started using some tools from http://www.red-gate.com/ So far so awesome! Adrian http://www.adrianlynch.co.uk/ 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

+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

+2 for Red Gate. -jeff >+1 for Red Gate's tools. > > >-- >Thanks, > >Tom

On Thu, Apr 3, 2008 at 11:16 AM, Gerald Guido <gerald.guido@gmail.com> wrote: ----- Excess quoted text cut - see Original Post for more ----- 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/

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 +2 for Red Gate. -jeff >+1 for Red Gate's tools. > > >-- >Thanks, > >Tom

Thank you for the help. G On Thu, Apr 3, 2008 at 12:01 PM, Brad Wood <bradwood@nationsholding.com> wrote: ----- Excess quoted text cut - see Original Post for more -----

+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. Thank you for the help. G On Thu, Apr 3, 2008 at 12:01 PM, Brad Wood <bradwood@nationsholding.com> wrote: ----- Excess quoted text cut - see Original Post for more -----