Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Best approach to have mssql 2008 mirror certain fields to MySQL on Web Expand / Collapse
Posted Friday, March 22, 2013 3:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, March 24, 2013 10:58 AM
Points: 1, Visits: 7
We have a mssql onsite server.

We want to create a Website probably using LAMP and designed with Joomla.

We want to link or mirror certain fields from our onsite DB to the DB on the Web, so that clients can go to the web and see their status, tracking,etc.

Should I create a new table in MsSQL called web, then mirror that to the Web host?

I would like some suggestions, as to what may be the best approach.
Post #1434531
Posted Friday, March 22, 2013 8:03 PM



Group: General Forum Members
Last Login: 2 days ago @ 3:25 AM
Points: 7,933, Visits: 14,355
Mirroring is a specific concept in SQL Server but I am guessing you meant it generically because you cannot mirror to anything but another instance of SQL Server and you can only mirror an entire database, not just single tables.

In terms of SQL Server you are probably after 'Replication' which can be setup at the table-level. Sadly however, replicating data from SQL Server to MySQL is not something Microsoft officially supports. You could look for guidance online to see if someone else has achieved it, or look for third party software to help.

Rather than trying to replicate data to MySQL, can you simply connect to SQL Server from Joomla? SQL Server is a far more robust platform than MySQL. Think of it as a LASP stack

There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1434557
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse