Create and connect database at runtime

[nikhiljain27]

I have to create database at run time and connect to oracle or anyother database through coding. That autmatically new database or connect to database and create tables along with installation of application. As it done in case of demo version . How it could be done Plz. tell me.

 

[ManicCW]

when you create a database in sql server you can automaticly script your database using sql server, visual studio or some other product (like redgate's sql products). when you create scripts (*.sql) you can run them from installer class or from some form in your app. i use the second method. when user first start his app the app checks if database exists and if does not then it is created. i you like this method i can post you some code.

 

[nikhiljain27]

Thanks

Thanks ManicCW,
i got ur reply, my problem got solve up to great extent but their a problem unsolved that how i can create database at runtime or through code or syntax to script to create database.


Thanks,
Nikhil