Forum Moderators: open

Message Too Old, No Replies

SQL Provider.

MSSQL vs. MySQL?

         

Dabrowski

1:28 pm on Jun 4, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



ok,

I have a database system that's growing rapidly. That's not the problem, the problem is I want to replicate the server for fault tolerance.

I'm running 2x MS SBS Server, which comes with MSSQL, but I believe a limited version of it. I don't know the limitations as I downloaded the free MySQL and have been using that instead.

Anyone know if the MSSQL that comes with SBS supports replication? The full versions of both are expensive, and I'd rather not have to spend on them if need be.

I've got the DNS, IIS config and the actual files all sync'd nicely, just need the DB to fall into line.

FalseDawn

12:22 am on Jun 5, 2007 (gmt 0)

10+ Year Member



SBS comes with the workgroup edition of MSSQL, which supports limited replication features, although the number of clients is limited.
SQL Server database mirroring is a _much_ nicer solution, but as you say, you'll have to pay for the convenience.

Dabrowski

11:05 am on Jun 5, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Thanks for the reply Falsedawn. I did the research and came up with the same conclusion unfortunately.

I'll stick with my single installation for now, until I have a spare £1,500 per year!