I have an application where I need to replicate rows from one server running MSSQL (Currently running a Microsoft Dynamics instance) and send them to a MySQL server. I'm currently thinking of doing this with an ODBC connector, but I'm not sure that's going to work.
If it doesn't, I'm looking for a common file format which can be recognized by both MSSQL and MySQL. Any ideas?
Billy3
Full Version: Mssql To Mysql Database Connection
http://dev.mysql.com/tech-resources/articl...-microsoft.html
There is no reason to do it yourself when there are already tools to do it for you.
There is no reason to do it yourself when there are already tools to do it for you.
Hello, groovicus.
I would assume you are refering to this?
http://www.kofler.cc/mysql/mssql2mysql.txt
True, but I don't have the option of doing this manually... it has to execute from a batch script nightly, without intervention.
Billy3
I would assume you are refering to this?
http://www.kofler.cc/mysql/mssql2mysql.txt
True, but I don't have the option of doing this manually... it has to execute from a batch script nightly, without intervention.
Billy3
Then might I respectfully suggest that if you are having to make nightly transfers from one sql database to another, then there is a serious problem in implementation. There are any number of things that can happen when migrating data (which is why it isn't something that should be done every night). Is there a really good reason for operating like this, because this is a horrible idea. What is it that you are trying to accomplish exactly?
Hello, groovicus
We have an internal server running MSSQL and Microsoft CRM, which has a knowledgebase section. The external server is running MySQL and Joomla!. The servers can't connect because there's a firewall between. An SSH tunnel is connected for ~ 30 seconds through the firewall when updates to the dataset on the internal server can be replicated to the external server. Not much I can do about the implementation... I'm only tasked with making a converter, not with setting things up
I agree with you that it's not such a good idea.
Billy3
We have an internal server running MSSQL and Microsoft CRM, which has a knowledgebase section. The external server is running MySQL and Joomla!. The servers can't connect because there's a firewall between. An SSH tunnel is connected for ~ 30 seconds through the firewall when updates to the dataset on the internal server can be replicated to the external server. Not much I can do about the implementation... I'm only tasked with making a converter, not with setting things up
I agree with you that it's not such a good idea.
Billy3
Forgot to add...
I figured out a way to do this:
I have to write sort of a custom program to handle it, but I'm just going to use an ODBC Connection to each database. We'll see if it works :D
Billy3
I figured out a way to do this:
I have to write sort of a custom program to handle it, but I'm just going to use an ODBC Connection to each database. We'll see if it works :D
Billy3
Not that I think anyone cares, but that's what I ended up doing ;).
Not final code, but in case anyone's interested:
http://billy-oneal.com/joomlaUpdaterProtot...totype/Form1.vb
Yes, the Big Wigs at work need to get their skulls screwed on straight ;). What a nasty system design
!
Billy3
Not final code, but in case anyone's interested:
http://billy-oneal.com/joomlaUpdaterProtot...totype/Form1.vb
Yes, the Big Wigs at work need to get their skulls screwed on straight ;). What a nasty system design
!Billy3
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.