c#,mssql developer

MSSQL JIWA is an accounting package ([login to view URL]) we are accessing data directly via the database on mssql 2008 r2 We already have a view in the foamexpolydatabase, we need to make this view in the foamexcentral database We may need to replicate any custom fields that are needed inside the foamexcentral so they are the same We currently have a c# ( I should be able to get any source or project file for this if needed) import and export process that runs via a schedule. This export/import is done using CSV I can assist via teamview and skype 1. Create view in foamexcentral from foamexpoly 2. Create any custom fields that the view may require 3. Edit the export process to export from foamexcentral and add to the csv that is created a field called source and label FC for foamexcentral and FP foamexpoly. 4. Edit the Importer to import the data back to the correct database from the source field 5. Edit the importer logging system to log in more detail but only for errors and activity any scheduled task that has no activity are not to be logged.