Can we create database tables/script from DataSet

[Guest]

I need to create database tables and relationship on fly in database (SQL Server/Oracle) based on the schema specified in the dataset. Or Is there some tool or easy way to generate the SQL script from dataset that user can run manually to create database schema? It would be great help.

Thanks
Niraj

 

[Miha Markic [MVP C#]]

Hi,

No, there is none AFAIK.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

I need to create database tables and relationship on fly in database (SQL

Server/Oracle) based on the schema specified in the dataset. Or Is there
some tool or easy way to generate the SQL script from dataset that user can
run manually to create database schema? It would be great help.

 

[Mary Chipman]

You could always write your own script generator, matching the
properties of the dataset to the SQL syntax needed for the DML
statements for SQLS and Oracle, and write it out to a text file. I
don't know much about Oracle, but T-SQL is well documented in SQL
Books Online.

--Mary