I know that VB6 and VS 2005 are old, but for various reasons, for this project, I was stuck with them. Therefore, if I need to go to something other than LocalDB for the embedded database application, feel free to tell me about it.
I am an experienced programmer, but I have always developed applications in well-known client workstation environments. I know which database is installed (e.g. SQL Server Express), and that these instances are being called. This project is different in that I have a small application with a built-in database. No multi-user access, no security, just a user with access to their own data. A database is basically text (mostly nvarchar, some ints) and there will be many rows (from 400,000 to millions), but small records. No stored procedures.
I need to deploy this on client workstations. I need to create my database from the application and attach to it (only on the first start). All this happens on the client machine. I looked, perhaps using SQL Express or SQL Server CE, when I came across LocalDB, but I read some places that might occur when accessing with VB6 or VS2005. If so, then I need to know if I should switch to CE or even something like Access MDB.
The main problem is a simple installation for the user.
Thank you for your help!
Michael Mack
source
share