Suoritettu

One way sync from MSSQL (LAN) to MySQL (internet)

We need a small piece of software, really lightweight that must run on Windows Server 2012 and do a ONE-WAY sync of an MSSQL View in the local network to a MySQL database in the internet. It is a product database. Right now we have something very similar that weighs 400Kb in total.

It would ideally run in text mode, and output a file log with the results of each run.

We take care of periodic execution.

Some fields in the MSSQL have to be mapped to the MySQL fields (can be in different tables). It must perform datatype conversions if needed.

It will be synced by a UniqueIdFieldName. If UniqueIdFieldName exists in MSSQL but not in MySQL, it will create a record in MySQL and store the rest of the record related to this UniqueIdFieldName, AND it will set the Visible_Field in MySQL to None, AND it will set Field_Cat to an XML parameter (Wait_Cat). This is because product will be flagged as hidden and Waiting to be published.

If MSSQL UniqueIdFieldName already exists in MySQL, it will update the rest of fields accordingly.

There is a special field in MSSQL that will trigger a special action:

Wether or not the UniqueIdFieldName previously existed, or had to be created, if the MSSQL field is set to Discontnued_Code (constant given by XML setup file), in MySQL the Field_Cat must be set to Discontinued_Cat (constant given in XML) and depending on a global parameter in XML, it will set Visible_Field.

An XML file (structure to be freely defined by developer) will be used as a config file, including:

Wait_Cat

Discontinued_Code

Discontnued_Cat

Discontinued_Visible

MSSQL address (name or IP)

MSSSQL user

MSSQL password

MSSQL database

MSSQL Viewname

MySQL address (name or IP)

MySQL user

MySQL password

MySQL database

MySQL Viewname

Mapping of fields

MSSQL UniqueIdFieldName

MySQL UniqueIdFieldName

MSSQL_FieldName, DataType to MYSQL_FieldName, DataType

Taidot: MySQL, SQL

Näytä lisää: phonegap internet mysql, sync mssql remote mysql, sync local mysql remote mysql, sync mssql mysql joomla, php sync mssql mysql, sync mssql mysql php, php mysql sync mssql, mssql export wie bei mysql, php script sync mssql mysql, mssql money data type mysql, mysql linux mysql process gets created, sync mssql mysql, need php script sync mssql mysql, import mysql database mysql database, php mysql browse submit edit view delete update

Tietoa työnantajasta:
( 0 arvostelua ) Spain

Projektin tunnus: #16290925

Myönnetty käyttäjälle:

hanlan

Hey, I'm interested in your project. Please send me a message so that we can discuss more. I will make a C# console application to deliever these requirements. Can start work on it right away. Best Regards.

€240 EUR 2 päivässä
(3 Arvostelua)
2.5

13 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

mkoteshwar

I work with both mssql and mysql regularly and will be able to deliver a working program quickly. I can setup the same environment, demo it for you and then deploy it in your environment or hand it over with configura Lisää

€138 EUR 4 päivässä
(4 arvostelua)
3.6
AllProgs

Estimado, tengo amplia experiencia en bases de datos y desarrollando, puedo realizarle la sincronización que necesita desde la sql server hacia MySQL, para ello necesitaría un backup de la base de datos o por lo menos Lisää

€120 EUR 2 päivässä
(7 arvostelua)
3.6
DigitalRace

Hello! I am an expert in web development and have 10 years of experience. Especially, MSsql and Mysql are my best experience. Please contact me, you will get a wonderful result. I will wait for your reply. Thanks. Lisää

€155 EUR 3 päivässä
(5 arvostelua)
3.1
hamzafiaz0003

Hello we can develop MSSQL synchronization software for you exactly as you describe.I read your description & exactly got your requirements We are team of Professional software developers 4+ years [url removed, login to view] Lisää

€300 EUR 2 päivässä
(1 arvostelu)
3.0
CyberLeafSol

Hello, I am interested, can develop an app in asp.net before transfer it will provide a facility of connection with database with its credentials. Let’s talk!

€244 EUR 10 päivässä
(3 arvostelua)
3.2
FullStackService

hello,how are you.i read your bid carefully. i am MsSQL, MySQL expert and have full experience for 12 years. also java/javafx is my top skill and passision. i can provide most quality and high speed. if you want to Lisää

€155 EUR 3 päivässä
(2 arvostelua)
3.1
imranrazawi

I have very good skills and big experience in developing MS SQL server with mySQL and also developed different database solutions.

€155 EUR 3 päivässä
(3 arvostelua)
2.9
yingji0504

Hello. I am a professional programmer on PHP+MySQL+WordPress. I am very flexible in working time and communications. I can follow all your requirements and can advice good solutions to accomplish this job effectivel Lisää

€155 EUR 3 päivässä
(0 arvostelua)
0.0
sayanprogrammer2

Hey ! I've reviewed your complete job description, and I fulfill all the qualifications required for this project. I have done many projects and I always try to provide good quality work to my clients. Lisää

€44 EUR 3 päivässä
(0 arvostelua)
0.0
aslamshaikh017

Respected Sir/Madam. Through this proposal I would like to convince to assign this task or project.I will give my best result and satisfaction apart of the work. If you hire me than I will make some additional functio Lisää

€111 EUR 3 päivässä
(0 arvostelua)
0.0
aaz256

Hi! I've got your project proposal about an application, that must perform a syncronization from MSSQL to MySQL. I'm a professional software developer with 15 years of experience, have a large expertise in both mention Lisää

€133 EUR 5 päivässä
(0 arvostelua)
0.0
textom

We are interested in your project. Your requirements are well defined. We have lots of experience in this type project. We look forward to hearing from you.

€222 EUR 10 päivässä
(0 arvostelua)
0.0