I may be wrong, but I don't think it is possible to do dynamic load balancing between both instances in an active/active cluster (ie having incoming requests dispatched on the...
One of our apps uses several databases. We use a 2-nodes active/active cluster with one instance of SQLServer on each node, and the various databases balanced between the 2 nodes...
I had a quick look at the online demo version. It looks like a nice tool for some specific needs, for example when you need to move often from machine...
Depending on the size of your database, why not do a snapshot replication and update it a few times a day ? Schema changes seem to pose no problem with...