I'm working on a new SQL Server landscape for the region I'm responsible for, today we have 14 MS SQL Server installations spread across 7 different physical sites.
The sites are all connected trough our Corporate WAN, which for most sites gives us only 512kbit to 1Mbit connection speed.
Now we want to centralised some of the SQL Server databases so that we can reduce the total number to 7 SQL Server installations, most of them will be centralized into 1 big SQL Server in the main site of the region (which currently has a 4Mbit connection).
Connection speed is not that fast, but it is sufficient today. After centralization we will need to upgrade some lines, but actually I would like to look at other solutions which could improve SQL Server communication.
Does anybody have any experiences with this?
If it works it sound like a pretty good solution, and not that expensive. The only problem is that their website doesn't really give me confidence...
Does anyone have any other solutions?