Creating an SQL Database from an ADO.NET Typed Dataset

Question

I have a DataSet defined and developed in visual studio.

Who knows the tool for creating tables in SQL Server to match a dataset.

Answer 1

Here's an article I found very useful in creating a class to do just that.

http://social.msdn.microsoft.com/forums/en-US/adodotnetdataproviders/thread/4929a0a8-0137-45f6-86e8-d11e220048c3/

Answer 2

I don’t know any tools that will do this just like that, but you can always use SMO (SQL Server Management Objects) to read your DataSet and create database tables.

Mark