SQL database synchronization - General SQL Database Question & Answer

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Database Administration » General SQL Database Question & Answer » SQL database synchronization

SQL database synchronization

Options

Previous Topic · Next Topic

Tanai

Posted: Wednesday, April 16, 2008 11:25:39 PM

Rank: Newbie

Joined: 4/16/2008
Posts: 2
Points: 6

Please can somebody help me with the following:

Our company has an enterprize site (a very large one). From time to time we need to make changes in it. In other words, we had to synchronize one database (local where we make all changes) and database on hosting. So, we did it manually (wrote scripts and inserted them in database on hosting). But as the databases grew it became impossible to synchronize everything manually. So we need some tool which could cope with this task. The problem is that, as I know, there are many tools which can do it, but we are tight in time and can't evaluate them all. Please share your ideas on what tool is worth evaluating?

Thanks in advance.

Scott Whigham

Posted: Thursday, April 17, 2008 8:23:01 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

We have to do this for our sites - we host our SQL database remotely and develop locally. I went the same route you did - hand written scripts - and I'm now having "growing pains" with those scripts just like you. Unfortunately I haven't found the perfect tool yet. I'm trying out Red Gate's SQL Data Compare now.

Tanai

Posted: Monday, April 21, 2008 2:36:55 AM

Rank: Newbie

Joined: 4/16/2008
Posts: 2
Points: 6

Yes, we evaluated Red Gate's components, but all these tools (Red Gate and similar to it) should be installed only on the local machine, and they can't be installed on server. So, the whole synchronization process occurs locally what loads traffic. We wanted to have some web service which will make all the work on the hosters server.

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.