Hi all, 1st post so be gentle, had a search and seem unable to find anything relating to this.

I am currently creating a small program to take 4 tables (currently) from an Access DB where modifications are made and update 2 different Remote Server based MySQL databases. I am using C# and .NET. I also have the MySQL Connector extension from their website.

I have been asked to replicate the actions of an ASP script (too unreliable), in creating a copy table before moving the data into position (if that makes sense! :))

Basically as all the tables are different and there is potential for more to be added later, I want to be able to create the new tables in the MySQL db programmatically using the schema or some other method from the DataSet. (As its basically a copy)

Now can anyone offer some advice on how I would 'convert' the schema into a MySQL/SQL format to create the table? I.e. is there an easy way to do this such that I don't have to create a function to convert and support all datatypes etc?

I'm also a bit new to remote db's, if you can't already tell.

Thanks in Advance
Anno

Edited to add, its .NET 2.0