Devam Ediyor

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 )

Beceriler: Microsoft SQL Server, SQL

Daha fazlasını gör: 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

İşveren Hakkında:
( 0 değerlendirme ) Barcelona, Spain

Proje NO: #17870379



Hi, I have 13+ years of experience in web development using Asp.Net with C# and with SQL Sever and Visual Studio. Strong in design and integration problem solving skills and bug fixing and changes in existing Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 111%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(0 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde211%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(12 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde120%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

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.

in %bids___i_period_sub_35% gün içinde120%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde277%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde222%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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.

in %bids___i_period_sub_35% gün içinde222%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde170%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)