Click here to Skip to main content
13,301,100 members (74,416 online)
Rate this:
 
Please Sign up or sign in to vote.
Hi All,

I have a requirement to export 100-150 tables from Sybase out to .csv files on a daily basis.
I also need to export the metadata of each table (column names + data types) so when i import them, i dont have to guesstimate the metadata.

What I have tried:

I have gotten this first part done successfully using the code from here:

Welcome To TechBrothersIT: C# - How to Export Data from SQL Server Table or View to Text File in C Sharp[^]

However i believe i need the metadata when importing these files back, otherwise how would the code know which data type to set the column to?

I am still not sure about the code for the 2nd part, which is, how to import these files back into tables using code. I assume this is where i need the previously generated metadata to figure out the data types.
3rd party add-ons are not an option, hard requirement to to use file based CDC hence this is my only option.
Anyone can help on this?
Posted 10-Sep-17 3:44am

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy |
Web01 | 2.8.171207.1 | Last Updated 10 Sep 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100