March 22, 2013 at 3:33 pm
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.
March 22, 2013 at 8:03 pm
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply