FRIHOSTFORUMSSEARCHFAQTOSBLOGSCOMPETITIONS
You are invited to Log in or Register a free Frihost Account!


database synchronisation





koen66
anyone has suggestions for synchronization of two sql server databases. I've been investigating the option for using the ms synchronization framework. The learning curve is quite high.
Does anyone have some experience with this framework? Can someone provide some worked out real world example?
What are the real contras to it?
Are there other solutions (open sourceŕ?
AftershockVibe
I've used MS SQL, this was back with SQL Server 2000 and 2003 though. What I used was just called "replication" and probably now comes under what they've decided to call the synchronisation framework.

Anyway, it was pretty straightforward to set up - dead easy using the server admin tool, although I eventually used SQL scripts which was harder. What exactly are you finding difficult?

Because replication is such a big part of DB requirements then I'd imagine that all the big name engines support it. I did a quick look for Postgre and MySQL, the big Free and Open Source names, and there are definitely solutions available for those.
harismushtaq
I am not familiar with the synchronization framework but if it is the same as replication in SQL server 2000, then I'll recommend using it and I think the learning curve will not be very steep.
albuferque
You ought to check SQL Compare, using it would be the "easy" way.

The advantage of this application is that one is no longer worried about making changes to frontend applications. Once you're done developing new features, it's as simple as firing up SQL Compare and running it on my product server and within a few seconds your databases tables, stored procedures and everything else will be updated to the latest build.

For details check this:

http://www.red-gate.com/SQL_Compare.htm
Related topics
WTF! A strange database just appeared lol
script backup database
How much database
database problem
Implementing your database access in PHP as a layer.
how can i change password in my database?
Database Problem
How to restore database?
Need help with database, can anyone help?
Navigation Script (javascript) Help Please!
I can't upload my Database SQL script ! Helllppppp!!!!
Strange Mysql-database
MySql Database
Critical Database Error (Or something else)
Reply to topic    Frihost Forum Index -> Computers -> Operating Systems

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.