Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BartMan
Starting Member
22 Posts |
 Posted - 2004-08-09 : 12:28:54
|
| Greetings, I am creating an application which will create a database and it's tables one time when it starts up. After that any time this application starts up it will check to see if a database item exists (such as the database itself, a table, procedures, functions, triggers, ect), and only add the items in which it needs, or doesn't exist.I was curious as to any suggestions that people have as to doing there database related creation. I was thinking about having sql scripts and running them from ado.net, but I thought I would would check and see if other people had different suggestions as to how this is done. My application will be created using c# and window forms (either visual studio 2003 or possibly 2005 beta) on an xp platform.Thanks in an advance for any suggestions, or opinions! |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2004-08-09 : 18:21:24
|
| So your basically creating some sort of plug'n'play application? Could be you'll run into some permission-problems but if you overcome those it's just a matter of querying the master-database. I'm usually not a fan of unassisted database installation but I guess it could be done... |
 |
|
|
|
|
|
Suggestions on ways to perform Database Creation?