ODBC and C# question

[Guest]

Hello People,

I am trying to connect to the database (for example: Food) and get all the
tables from this db and transfer them all into one XML file.
The problem is: I am not sure how to save the relationship between the
tables.
Because, after I will need to parse this XML file and create all the tables
in new DB with all previous existed relationship.
Could any body give me some examples, some hintch, or anything how to do
this.
Huge "thank you" in advance.

Oleg Shnayderman

 

[Nicholas Paldino [.NET/C# MVP]]

Oleg,

Instead of writing this yourself, have you considered using the Data
Transformation Services that come with SQL server? They allow you to take
data from one source, and transfer it to another (it could be ODBC, text
files, anything). It's much better than rolling your own solution.

Hope this helps.