Suljettu

MSSQL to MySQL

I need either a Windows or Linux program or even a DTS package that can be ran as a scheduled task or through a cron job. I need to be able to dump parts of my MS SQL server database to a MySQL database on my webserver.

The problem is that the source (MS SQL) contains some text fields with over 8000 characters and DTS generates "query based insertion of blob values is not supported" errors.

Preferably I would be able to select the source / tables (MS SQL) and the destination / tables (MySQL) and set the time(s) the data transfer would occur. Before each table is transfered, it would first truncate the destination table before any rows are inserted.

Taidot: C-ohjelmointi, Linux, Perl, Python, Visual Basic

Näytä lisää: job values, webserver, sql mysql, rows, mysql to sql, mysql query, mysql mssql, mysql and sql, mysql 4, mssql mysql, c mysql, mysql characters, mysql inserted, scheduled, table perl, perl table, query mssql, database dump, mysql tables rows, mysql source, source destination, cron mysql, query text mysql, perl webserver, query based time sql server

About the Employer:
( 0 reviews ) Shelton, United States

Projektin tunnus: #5797

18 freelanceria on tarjonnut keskimäärin 342 $ tähän työhön

siddhartha1

Sir, we can provide you the solution of your requirement, pls contact via pm

500 $ USD 18 päivässä
(10 arvostelua)
6.5
DougRoyer

I have written many MS and MY SQL programs. Having one convert should not be a problem.

100 $ USD 5 päivässä
(8 arvostelua)
6.1
eccentricworld

hi, we can do this in good manner. regards sri

270 $ USD 5 päivässä
(7 arvostelua)
5.4
webrains

Dear sir, We are pleased to introduce ourselves as a software development firm based in Bhubaneswar since FEB 2002. So far we have completed nearly 300 + projects. We are proud to have few the most esteemed clients in Lisää

499 $ USD 7 päivässä
(2 arvostelua)
4.0
xenon79

Hi, if the project is still available, please send me an example (the structure of the MS sql and the MYSQL databases and a few records) and I'll make a beta version with no obligations for you. Lisää

170 $ USD 3 päivässä
(1 arvostelu)
2.8
eenavin

can be done

200 $ USD 7 päivässä
(1 arvostelu)
2.0
sunita12

Hello, I have wide area experience in open source technology like php/c++/linux/so files/fusebox AND WINDOW based ASP,COM,DCOM,MTS,VB,VC++,.NET,Flash Please forward me your mail ID so i can forward you project proposal Lisää

450 $ USD 15 päivässä
(1 arvostelu)
3.3
halwasiyainfosys

Dear Sir, We have understood your requirements and can easily do the project as we are having more than 5 years of experience in IT industry and we are India's leading IT company. We offer 100% satisfaction and money Lisää

100 $ USD 5 päivässä
(0 arvostelua)
4.0
Subbiah

Dear Sir/Madam, United Techno Solutions, based at Boston, MA is a software consulting company with expertise in database technologies and web related services. We have proved our competence in these technologies wit Lisää

400 $ USD 15 päivässä
(0 arvostelua)
0.0
rschipie

Hello people, I can fix this for you but have a look at the PMB.

500 $ USD 7 päivässä
(0 arvostelua)
0.0
nidle

Dear Sir/Madam. We had carefully examined your project and got your idea. We can provide you EXACTLY WHAT YOU NEED!!! We had already developed a great number of projects similar to yours and have all the required skill Lisää

420 $ USD 15 päivässä
(1 arvostelu)
4.6
erhardsmit

Hi. I can write a windows program that can run on scheduled intervals to dump data from the mssql db and then import the data into the mysql db, truncation and any other rules you need I can incorporate in the program. Lisää

200 $ USD 7 päivässä
(0 arvostelua)
0.0
jultom

We can do this script using VB with ODBC ( MyODBC for MySql ). We can develop a generic conversor. Regards, Jultom.

250 $ USD 15 päivässä
(0 arvostelua)
0.0
ftimes

I can't work out what your platform arrangement is from the details you give but here is a solution. This can be done with php and an ODBC driver to MS SQL and PHP's own driver to MySQL. Then use PHP to migrate the d Lisää

500 $ USD 21 päivässä
(0 arvostelua)
0.0
bid1

we can do it.

500 $ USD 5 päivässä
(0 arvostelua)
0.0
sarabjeetkaur

We have fairly good experience in database applications on various platforms. We have our development centre in India equipped with all the necessary skill set. Please visit our website for more details at www.soft<b>< Lisää

300 $ USD 7 päivässä
(0 arvostelua)
0.0
inavigators

We wish to introduce iNavigators as an Information Technology arm of Rungta Enterprises, a multimillion-dollar conglomerate that was conceived with a singular charter to provide quality software solutions and to cater Lisää

500 $ USD 10 päivässä
(0 arvostelua)
0.6
dhavalgs

We can provide u the solution. Please see PMB

500 $ USD 30 päivässä
(0 arvostelua)
0.0
gunjankvel

We are a group of professionals having more than 5 yrs experience.We can do the work for you

300 $ USD 5 päivässä
(0 arvostelua)
0.0