October 5, 2007 at 8:37 am
All,
We have a mix of hosted and client side databases. One of our hosted clients also has a local database and asked us for the data to be replicated.
Easy - we can use replication over VPN and we'll get the job done.
However, I was wondering if there were any good 3rd party tools out there? I'm starting to look around for some now, but I'd appreciate any feedback on tools you have used.
Cheers,
Clive
October 5, 2007 at 8:57 am
You moving all data or selected sets?
For client side, I assume you mean some database at the client's site and not client machines?
October 5, 2007 at 9:46 am
Selected tables. 80% of tables are static or rarely changed.
October 5, 2007 at 11:41 am
You should narrow down your replication needs first. An understanding of how much data there is overall, how many changes there will be to this data, the performance of your VPN connection, acceptable latency, etc. will make it much easier to make a good choice on how to do this.
That being said, before SQL 2005, replication for part-time connected devices was in some ways less than stellar. SQL 2005 replication (particularly merge replication) is very stable and relatively easy to manage.
Start with the plan for how you would do this with SQL replication and that will allow you to choose a vendor that excels in that particular area and understand the total costs of using what you have or getting some third party tools.
Keep in mind that the more vendors you have involved in a process, the more they can point fingers at each other when you have a problem.
November 6, 2007 at 2:19 pm
KISS - I see so many companies using sql server that keep paying for crystal report when ssrs is amazing and built in, or they buy Informatica to solve etl issues when ssis is built in, or buy 3rd party repl tools to solve sql repl requirements...
Don't be too quick to dismiss sql to solve your sql problems - give the built in tools a try... save yourself a few bucks... these aren't just simple add-ons anymore -
my 2 cents
ChrisB MCDBA
MSSQLConsulting.com
Chris Becker bcsdata.net
November 7, 2007 at 6:29 am
We have used Redgate with amazing results. I agree with the others - check out what is built-in first. If you need something else for replication, check out Redgate. It is very easy to use. Especially under 2000, Redgate turned my four year worry (client data not sync'd) into a footnote.
November 7, 2007 at 6:32 am
SQL replication was my first choice and I had replication all working but it was also required to see if there was any 3rd party alternatives out there.
That said, the project has now been canned! :crazy:
Thanks for the replies though.
May 12, 2011 at 3:56 am
I've seen doubletake software used in the past
May 12, 2011 at 4:26 am
The project was un-canned and in the end we just stayed with traditional SQL Server replication.
Although we now have a client who wants their data replicated but doesn't want to use replication....And no deletes of data...
All fun and games :hehe:
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply