We have a MSSQL database sitting on a remote server that has a built in online services (web) module which displays web pages written in asp. Our current online prescence is restricted to updates, joining (subscriptions) and renewals and most importantly a searchable members directory...
Unfortunately the system hasn't been developed in 7 years and we wish to move on by using a Joomla driven website with Community Builder and CBsubs.
My understanding is that the SQL database is quite tightly locked down (my last employer investigated integration with a third party application and had to purchase a rather 'restrictive' API) but I am aware of other users having built their site in Joomla so there must be a way of synching.
I am looking for someone who can assist in synchronising the MSSQL db with the joomla mySQL db and community builder. We are looking to have quite a lot of functionality on the site but really only wish to sync data with the MSSQL db data that is relevant to certain individual attributes (lookups) and of course payments.
I am only looking for developers with experience in this matter and would request an explanation of how the synch would work.
Unfortunately we are a not for profit organisation so money is a wee bit tight.