|
Mailing Lists
|
Home /
Groups /
ColdFusion Talk (CF-Talk)
OT - Database schema compare/sync tools for MSSQL
Author: Jim Wright
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:55873#303254
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/
Author: Jenny Gavin-Wear
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:55873#303220
+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 -----
Author: Gerald Guido
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:55873#302648
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 -----
Author: Brad Wood
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:55873#302628
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
Author: Jeff Price
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:55873#302626
+2 for Red Gate.
-jeff
>+1 for Red Gate's tools.
>
>
>--
>Thanks,
>
>Tom
Author: Tom McNeer
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:55873#302621
+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
Author: Adrian Lynch
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:55873#302616
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
Author: Dawson, Michael
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:55873#302612
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
Author: Gerald Guido
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:55873#302610
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
|
May 24, 2012
|
Latest Fusion Authority Articles
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||