SQL Server Replication from local to remote
We have 2 master tables (Sales Invoice Header, Sales Invoice Line) + union with a query, so, we have 2 sql server views based on invoices (header, lines). 2 views.
this 2 views are stored in SQL Server in OFFICE 1
OFFICE 1 fullfills this 2 tables every XX hours. and sql table views collects additional information from SQL Server. (invoices + customer details)
OFFICE 2, needs to get registers from the 2 views each XXX hours. and be inserted in 2 tables.
Both databases are in diferent location/network.
I need a development in office 1 that:
Executes view 1, view2, taking last 1.000 registers on view1 and 3.000 registers on view2. (registers can be parametrized in code)
Save this information in XML file from view 1, and XML file from view2 (2 files with timestamp on the file name)
We will install a FTP Sync to take all files located in folder from OFFICE1 . This 2 files each hour and upload to OFFICE2 Server
Office2 server reads xml file that comes from Office1 and inserts this information in SQL SERVER tables in Office2
If registers exists, just replace them.
XML Sales Invoice Header, and XML Sales Invoice Line, will both have a unique key in order to insert and delete firs if exists.
Software development need to be done with VISUAL STUDIO CODE.
We will run in batch as a task from server, each xx hours.
Data will flow always from OFFICE1 to OFFICE2. office1 is onlyread database.
Visual studio code + sql server express edition + xml knowledge
Deliver source code.
Will provide a Virtual machine to test environment.
Development will not deal with ftp, this will be automatic with ftpsync.
Clean code in both sides.
We will provide table structure and table views in each case and a virtual machine to develop the project. Project will be done and tested in our VM. (windows server )
Hi, I have 13+ years of experience in web development using Asp.Net with C# and VB.net with SQL Sever and Visual Studio. Strong in design and integration problem solving skills and bug fixing and changes in existing Daha Fazla
Bu iş için 8 freelancer ortalamada $182 teklif veriyor
Hi i can develop this using etl tool and fulfil ur requirment please let me know
Hello. my name is Furkan Gözükara and i am a PhD computer engineer from Turkey I have developed many different c# application. I have always used MSSQL as my database. I have done batch processing applications as we Daha Fazla
Hi I have 5 year experience I can show you my precious work. I'm Individual freelancer I have no timing issue I can do work any time day/nights. so can we discuss once thanks.
Hi, Review my profile. 4 Years of experience as BI/ETL Developer and Oracle Business Intelligence Certified professional. Adept in preparing data for analysis, Creating dashboards deploying dashboards on server Daha Fazla
Problwm maybe resolved via Ssis job which will make it more operatable and monitored
I'm very familiar and experienced with developing against SQL server using. Net languages. SQL to XML to synch to SQL is absolutely no problem.
Hi There, I can do this task but with other approach things can be done. I am thinking to scheduler will execute at specific time. 1. it will take unique data from Office1 and Office2 and then updated to server. Daha Fazla