Can we create database tables/script from DataSet

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Hi,

No, there is none AFAIK.

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

Niraj said:
I need to create database tables and relationship on fly in database (SQL
Click to expand...
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.
 
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
 
Back
Top