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:
MSSQL address (name or IP)
MySQL address (name or IP)
Mapping of fields
MSSQL_FieldName, DataType to MYSQL_FieldName, DataType
9 freelancers are bidding on average €163 for this job
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!