I haven't tried, but it seems quite difficult, for one thing, both sql engines are very differents. So the short answer would be a plain no. Now trying something exotic would be making a odbc bridge between the two dbs and then use some scripted solution it would be possible, something like java or c# or even vb(.net), even perl or php could be used, but again it is something that you should find out for your self.
When deciding about what programming language one key comoponent should be that the language has native access to both server (php? perl?) so type coneversion would be easy to manage. But again it's just a thought... My two cents! =) maybe someone else here could have better ideas-options Best Regards On Thu, 2004-03-04 at 16:26, Daniel Ek wrote: > Once more - Dear list, > > I am doing some research on a CRM-tool which my company bought that uses > msSQL. > > The setup looks something like this > > User --> CRM --> MsSQL } > User --> Webform --> MySQL } The same data entered > > What would be optimal is if would be possible, that when a user requests > data through the CRM that it actually uses MySQL connections. > Unfortunately I speaked to the software vendor about it and they said > that it was not an option at the moment. > > My question then is if MySQL could replicate data with MsSQL as master > as following setup: > > User -> CRM -> MsSQL (<)--> MySQL --> Apps that relies on MySQL data > > I would be thankful to any comments and/or suggestions I can get > > Regards > > Daniel Ek -- |...........................................................| |____ _____ ____ _ |Victor Medina M | |\ \ \| ____| _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_____|_| /_/ \_\|ext. 325 - Tél: +58-241-8507325 | | |geek by nature - linux by choice | |...........................................................|
