DataSet to SQL
-
I have a populated data set (loaded from an XML file) that I want to put in a SQL database. Most of the tables in the DataSet are related, so I can't use a DataAdapter to update because I don't know the update order. All the examples I've seen about updating an SQL database only target one table or know the 'reverse-order' in which to update. Is there an easy way to store a .NET multi-table DataSet to a SQL database.
-
I have a populated data set (loaded from an XML file) that I want to put in a SQL database. Most of the tables in the DataSet are related, so I can't use a DataAdapter to update because I don't know the update order. All the examples I've seen about updating an SQL database only target one table or know the 'reverse-order' in which to update. Is there an easy way to store a .NET multi-table DataSet to a SQL database.
If you are using sql 2005 server then you could look at SqlServer Management objects(SMO)
transfer `method. This will allow you to move the whole schema and tables over at one time. SMO is not always the easiest to implement, but with a little monkeying around you should be able to get it to work. Check out an article I posted a couple weeks ago to get started, as well as search the site for SMO. There are not allot of resources on it but it might help. Aaron _____________________________________________________________________ Our developers never release code. Rather, it tends to escape, pillaging the countryside all around. The Enlightenment Project (paraphrased comment) Visit Me at [GISDevCafe](http://www.gisdevcafe.com)`