Closed

Export product data from the database to an excel file Synchronize data between the local database and the database that will be uploaded to the hosting

the first requirement

Restore the backup from this link

[login to view URL]

And it is restored using MS Sql management studio

And then a system is created that exports the data in the database to an Excel file in a specific format, and all the data in it is exported to 2 Excel files in a specific format

the first

A products Name

F products Number

L unit price

N barcode Number

P box price

Q Number of unit in box

the second excel file is in this format

A expired date

B product number

C barcode

D number of unit in store

E cost of the unit

F number of box in store

G cost of the box

J products name

the following technologies are used

1. C#

2. layered pattern

[login to view URL] framework core

[login to view URL] programming

[login to view URL] of work and repository pattern

[login to view URL] Design pattern

7. WPF

the second requirement

this is also for 2 databases for other systems, in the same manner as for the first requirement

the third requirement

[login to view URL]

A backup is for a system that was created using technologies

1. C#

2. layered pattern

[login to view URL] framework core

[login to view URL] programming

[login to view URL] of work and repository pattern

[login to view URL] Design pattern

7. WPF

It is required to link the local database with the database that will be uploaded to the hosting and they will be linked through A P I and the new data will be synchronized from the local database to the database on the hosting

And in order to be able to know the tables that have been changed and need to be synchronized, this is done by creating addition tables (that is, a copy of all the tables and the comparison is done constantly between the main table and the copy of it. If it is 1 (meaning a difference between the table and the other) then it is Automatically sync to hosting

If there is no difference between the two schedules, it is not necessary to synchronize it

And automatically if new tables are found, they are also created in the database in the hosting

It is required that the settings for linking the local database and the database on the hosting be in simple steps

Skills: C# Programming, .NET, Microsoft SQL Server, SQL, Microsoft Access

See more: export excel file web form, aspnet export datatable excel file, export excel file access database excel vba, excel macro export column text file, export datatable formated excel file using vbnet, mercury quality center export requirement excel file, export dataset excel file asp, export dataset excel file using vbnet, export dataset excel file using aspnet, export datatable excel file vbnet, export datatable excel file vbnet 2008, magento export orders excel file, product excel file opencart, export array excel file, update table sql management studio csv file, vendor product excel file data sheet, synchronize local and remote mysql database, read excel file in php and insert into database, vba code to open excel file from folder and copy data

About the Employer:
( 6 reviews ) tripoli, Libya

Project ID: #32160748

27 freelancers are bidding on average $1019 for this job

(14 Reviews)
6.2
(104 Reviews)
6.4
MSHOAIBK

Hi . I am an individual software engineer has a solid experience in ✤ Classic ASp | Vb .Net ✤ C# | .NET 5 | .NET Core | MVC 5 | ✤ Web API | Microservices | Blazer | REST ✤ Entity-Framework |[login to view URL] ✤ Sql | No Sql ✤ Lin More

$750 USD in 7 days
(29 Reviews)
5.8
(20 Reviews)
5.8
hsh564cf84accd96

We will do your work I am writing this proposal in order to work for you in Software and Web Development. We are highly trained professional developers seeking to freelance and earn online. Having a flair in programmi More

$750 USD in 7 days
(62 Reviews)
5.8
ivanovatale

I’ve spent most of my career developing with C#, vb.net During that time it’s been necessary to attain a working knowledge of many other technologies, including C#, Asp.net Web Forms,Asp.net MVC, SQL Server, MY SQL, S More

$750 USD in 7 days
(10 Reviews)
5.1
(25 Reviews)
5.2
harune

Hello. I am a Certified PMP (Project Management Professional) & Scrum (Agile) Professional offering services as Full Stack Developer (Frontend & BackEnd), having hands-on experience of developing small, medium and ente More

$1500 USD in 15 days
(17 Reviews)
5.3
(24 Reviews)
5.1
mihhailovajulia5

Hello. I have read your description very carefully and I can complete it perfectly in short time. I am confident in my skills and always value for client's trust. So I have rich experience in these fields. I can use th More

$1125 USD in 7 days
(4 Reviews)
4.5
pasievrakhim

Hi, Client As a Software Developer, I have 5+ years rich experiences working with C, C#, Qt, and so on. We have many years of strong experience in C++ Programming, OpenGL, Qt, as a result, we can successfully complete More

$750 USD in 7 days
(13 Reviews)
4.5
(5 Reviews)
4.6
(5 Reviews)
4.6
aminechafai14072

I am database expert with extensive experience from the field. I can definitely help you the required data movement and manipulation. Please reach out to me to discuss the plan of implementation.

$950 USD in 8 days
(10 Reviews)
4.3
vbtise

Professionals are accessible 24/7/365 to help you restore the backup, Using the link, MS SQL management studio is used to recover it. Then a system is established that exports the database's data to an Excel file in a More

$1125 USD in 7 days
(1 Review)
4.1
RomanMatveev1

A C# and SQL Expert! Hello, dear client! I am a professional C# developer and making UI with WPF is my most confident field. I have checked your requirements carefully. I can restore you data correctly and make a good More

$750 USD in 7 days
(6 Reviews)
3.7
fliudmyla1

Hi, Dear. Database Export! I`ve read your project post very carefully and I`m really interest in your project. I`ve rich 6+years of experience and knowledge in C#, .Net core, MSSQL, Exel. If you hire me, I can start ri More

$1125 USD in 7 days
(7 Reviews)
3.7
(1 Review)
2.2
SergeyKuznetsovv

Hi, ⭐@Your web expert here!!!@⭐ Please check calahex.com. I've read your job description several times and I eventually decided to bid. I've been a web expert for 5+ years and I think I am a best fit for your project. More

$750 USD in 3 days
(2 Reviews)
2.2
dPenXetri1

Hello, Very recently, I wrote a program that sychnronizes product /sales data between local database (Paradox ) and WooCommerce, Original goal was to export into CSV simply, but eventually with WooCommerce.. I believ More

$1125 USD in 7 days
(2 Reviews)
2.2