SQL Server Replication from local to remote

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 )

Taidot: Microsoft SQL Server, SQL

Näytä lisää: insert data sql server using visual basic net, sql server 2005 insert data csv table dts, insert data table using xml file sql server, insert data sql server vbnet application, code project insert data sql server aspnet, insert data csv file sql server, insert data datagrid sql server visual basic net, insert data dbase sql server, insert data design form asp net sql server, insert data sql server table xml file, insert data vb sql server database, insert data xml file sql server, mxml file flex insert data sql server, insert data excel sql server 2005, windows phone insert data sql, insert data in sql server using android application, how to insert data in sql server using android, how to insert data from one server to another in sql server 2008

Tietoa työnantajasta:
( 0 arvostelua ) Barcelona, Spain

Projektin tunnus: #17870379

Myönnetty käyttäjälle:


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 Lisää

$111 USD 7 päivässä
(0 Arvostelua)

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


Hi i can develop this using etl tool and fulfil ur requirment please let me know

$211 USD 3 päivässä
(12 arvostelua)

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 Lisää

$120 USD 7 päivässä
(1 arvostelu)

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.

$120 USD 2 päivässä
(0 arvostelua)

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 Lisää

$277 USD 10 päivässä
(0 arvostelua)

Problwm maybe resolved via Ssis job which will make it more operatable and monitored

$222 USD 5 päivässä
(0 arvostelua)

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.

$222 USD 2 päivässä
(0 arvostelua)

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. Lisää

$170 USD 10 päivässä
(0 arvostelua)