need a program
Budget: $10 – $30 USD
Create a program(s) that can take extract files and import the data into the specified tables
Use the file SOPN SORS MF to SQL Server Table Mapping.xls for all mapping details - it is in the SORS Migration folder
Each tab covers a different extract file which is named at the top and details all of the fields and where they map to in the SQL Server database.
The extract file fields are all Fixed-Length with | delimiters.
Source: Extract Files - SOPN (5 files) & SORS (12 files) - located in project folder in sub folders SOPN Extracts and SORS Extracts
Destination:
Server: AZAppDevSQL19 (this is the test database server, the production one will be different)
Database: SORS
Tables: Specified for each extract file, may be one or many depending on file, look at table field in mapping spreadsheet
.start your bid with "demo" that is necessary or also send demo videos how to hanlde it.
Start with the following tabs on the mapping spreadsheet, they are mapped and the tables have been created:
SORS DOB
SORS SSN
SORS SMT
SORS Soundex
Use the file SOPN SORS MF to SQL Server Table Mapping.xls for all mapping details - it is in the SORS Migration folder
Each tab covers a different extract file which is named at the top and details all of the fields and where they map to in the SQL Server database.
The extract file fields are all Fixed-Length with | delimiters.
Source: Extract Files - SOPN (5 files) & SORS (12 files) - located in project folder in sub folders SOPN Extracts and SORS Extracts
Destination:
Server: AZAppDevSQL19 (this is the test database server, the production one will be different)
Database: SORS
Tables: Specified for each extract file, may be one or many depending on file, look at table field in mapping spreadsheet
.start your bid with "demo" that is necessary or also send demo videos how to hanlde it.
Start with the following tabs on the mapping spreadsheet, they are mapped and the tables have been created:
SORS DOB
SORS SSN
SORS SMT
SORS Soundex