Comments
Sort by recent activity
@Eddie D Thanks for taking the time to respond. As it turns out I have just proven I can make some network config changes and be able to contact the remote databases directly, which is huge turning point for me! \o/ I understand I can only compare two databases at a time. I'd still like to log how many differences, warnings etc for audit purposes. I can see there is at least an exit code so the command line is turning into an option and I'm sure if I trawl through the output I could still get the additional information. However, I still don't see why the SDK is retired though; Surely it gives more control for developers. I'm sure I'll get over it but thought it important to provide customer feedback. / comments
@Eddie D Thanks for taking the time to respond. As it turns out I have just proven I can make some network config changes and be able to contact the remote databases directly, which is huge turning...
@dOCTOClone Thank you for your detailed replies. However I still cannot see how the links will provide the solution I need. The tools you link to appear to require a development database and a known deployment database which is contactable from our development environment? We have ~200 remote branches which could have any number of differences in their current schema compared with what it "should" be. They are on different versions of software and historically changes have not been audited. Frankly it's a mess, and now I've joined the company I'm trying to sort it out. I'm looking for a way for a routine to run on the remote client that will dynamically generate the required SQL to update it to a single given schema. SQLCompare seems perfect but I'm not about to purchase 200 licenses and manually go round each branch just because of our network setup. Hence me investigating SQLCompare API (which seems to work by the way). / comments
@dOCTOClone Thank you for your detailed replies. However I still cannot see how the links will provide the solution I need.The tools you link to appear to require a development database and a known...
@Eddie D Making the relevant changes to the command line examples you provided I have been able to get some output. I have a question though: Is it feasible (or sensible) to launch 184 instances of the command line at the same time. Each would compare a single staging DB (local) with a difference remote DB (over a WAN (MPLS)). Thanks. / comments
@Eddie D Making the relevant changes to the command line examples you provided I have been able to get some output. I have a question though:Is it feasible (or sensible) to launch 184 instances of ...
I have just installed Toolbelt (latest version) and cannot see SQL Change Automation in the View Menu. / comments
I have just installed Toolbelt (latest version) and cannot see SQL Change Automation in the View Menu.