Search code examples
sql-serverdatabasevisual-studiodatasetmdf

Creating DataBase (mdf) from DataSet

I have a DataSet consistint of a big number of tables of information. Is it possible automaticly create SQL Server DataBase (mdf-file) from description of my DataSet? Of course, I can do it manually, but may be there is a better way?

Solution

  • I have a XSLT script that will create DDL statements from a DataSet xsd. It's here. The database itself would have to be created, and you'd have to manually execute the SQL script the XSLT script created. But if you have a complex enough DataSet with enough tables, it might be preferable to doing it all by hand.