search

SoftUniTeamVolta / Supermarkets-Chain-

0 stars 0 forks source link

2. Replicate the Tables from Oracle DB and Load Excel Reports from ZIP File into SQL Server #8

Open minkas-g-d opened 9 years ago

minkas-g-d commented 9 years ago

Your task is to write a C# application to replicate the Oracle database tables to SQL Server database and load Excel reports into MS SQL Server database.

Input: Oracle database holding products; ZIP file with Excel 2003 reports Output: C# application that loads the Excel files into the SQL Server DB.

minkas-g-d commented 9 years ago

Tested the data replication from Oracle db to MsSQL db - everything is working fine.

TODO: The loading of Excel reports into MS SQL.