Creating Database during Installation
-
I am working on a windows app. I need to create a database during installation but more importantly, I need to know how my application would work on a computer that does not have SQL Server installed:wtf:. Since it is a stand alone app I am assuming that 99% end-users will not have SQL Server on their computers. Can I create a database if just the SQL Driver is available on client PC? or any other better suggestions? A code example will really be helpful. Thanks.:)
-
I am working on a windows app. I need to create a database during installation but more importantly, I need to know how my application would work on a computer that does not have SQL Server installed:wtf:. Since it is a stand alone app I am assuming that 99% end-users will not have SQL Server on their computers. Can I create a database if just the SQL Driver is available on client PC? or any other better suggestions? A code example will really be helpful. Thanks.:)
I have worked at places that do this in a couple different ways. You could copy the database files over to the machine and then attach a new database in SQL Server using a sql command. Or you could just generate the sql for the entire database and have that run on installation. In either case you will have to make sure that SQL Server is installed on the target machine. You can put the MSDE installer inside your installer and even SP3 for it too. SQL Srver is not like Access, you need to have the server running on the machine to get at it. For one product of mine, I switched to SQLite because that is accessed just as a file. I get most of the same features that I need and not much overhead. Steve Maier, MCSD MCAD