How to setup a local database for my application
-
Hello experts, I have build C++/MFC windows desktop applications which using MS-Access databases with ADO. The MS-Access databases which containing data are easy to include in the setup executable. My applications also have access to a MS-SQLServer database in a cloud location. Now I like to replace the MS-Access databases with local MS-SQLServer database. I only have to change the connection-strings for ADO in the applications. The only problem I think I have: 1. How to setup a local MS-SQLServer from my setup application. 2. How to deploy a not empty MS-SQLServer database. I don't know where to start, will you hint me in the right direction?
-
Hello experts, I have build C++/MFC windows desktop applications which using MS-Access databases with ADO. The MS-Access databases which containing data are easy to include in the setup executable. My applications also have access to a MS-SQLServer database in a cloud location. Now I like to replace the MS-Access databases with local MS-SQLServer database. I only have to change the connection-strings for ADO in the applications. The only problem I think I have: 1. How to setup a local MS-SQLServer from my setup application. 2. How to deploy a not empty MS-SQLServer database. I don't know where to start, will you hint me in the right direction?
-
What is the best replacement for the MS-Access database: SQL Server Compact or SQL Server Express? I want a silent setup easy to do by users.
-
That is not a good reason for choice of database, you should choose whichever one fits the business requirements.