October 28, 2002 at 11:29 am
Ok, here we go. I've got an Oracle 7.3 server that my current contract company wants to move over to MySQL for the money savings. We also have an MS-SQL 7 box doing basiclly nothing. I want to setup a two way DTS job that would pull from the oracle box and push to the mysql box untill we are ready to roll off of oracle completly. Does this sound remotely feasable? I've never tried to use MS-SQL server as a data buffer kind of server between products before.
Cheers,
Wes
October 28, 2002 at 1:15 pm
Should work fine if you get the drivers. DTS doesn't require SQL Server to run and this is a great application for it. I've used it to move between Access and Excel.
Steve Jones
October 28, 2002 at 1:17 pm
I've just never done it for two non-microsoft products. I'll give it a go and post some results 🙂
Wes
October 28, 2002 at 6:04 pm
Why use MySQL if you have the SQL box doing nothing?
Andy
October 28, 2002 at 6:51 pm
They only own a single proc lic for sql 7 they don't wish to use it if they don't have to. I am lobbying to keep it on since we actually own it. The Oracle lic is owned by our oursourced IT department and isn't something they want to buy. The word is cheap. So, I'll keep the sql box around to do grunt work and put up several MySQL boxes to handle data it's the only solution I have to work with.
October 31, 2002 at 11:50 am
Ok, This is what I have found so far. One, I can import from Oracle into SQL all day long. Two, using dbtools I can export from MS-SQL to MySQL all day long. Three I can't get DTS to talk streight to oracle and MySQL leaving the actual MS-SQL database out of it. This is how it breaks down. I tried to setup the DTS job to pull from oracle and push into mysql. No go. Failed on BLOB types of any sort. Pull from oracle into ms-sql fine. Push from ms-sql to mysql failed on blob types of any kind. I tried using the 2.50,3.50 odbc drivers for mysql and the oledb drivers for it as well no go. I can use a tool called dbtools to pull from a ms-sql odbc datasource into mysql but it isn't as fast as I would like it to be. Any ideas on why the blob inserts would be failing?
Wes
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply