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 )
8 威客就此工作平均出价 $182
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.