Database question
-
I was looking to create a small application that would just run on one or two systems and it would need a local database. What would be the best type of database to use in this situation? I would love to have something along the SQL lines so be able to use it's querying/database/stored procedure capabilities, but I don't know if that's a bit overkill for this application. The application itself will primarily be just a user interface for a customer database. David
-
I was looking to create a small application that would just run on one or two systems and it would need a local database. What would be the best type of database to use in this situation? I would love to have something along the SQL lines so be able to use it's querying/database/stored procedure capabilities, but I don't know if that's a bit overkill for this application. The application itself will primarily be just a user interface for a customer database. David
SQL Server Express Edition would be a good choice. It's a cut down version of SQL Server, but it gives you all of the benefits (such as transaction logs) that it's bigger sibling would give you. Plus it's free - and you can't argue with a price like that.
Deja View - the feeling that you've seen this post before.
-
SQL Server Express Edition would be a good choice. It's a cut down version of SQL Server, but it gives you all of the benefits (such as transaction logs) that it's bigger sibling would give you. Plus it's free - and you can't argue with a price like that.
Deja View - the feeling that you've seen this post before.
With SQL Server Express, would it be possible to have it install with the application itself? The program is one I am writing for a friend of mine and isn't something I will be using. I wouldn't want a complicated install process or a hard way for them to move the database files if they had to change computers. My friend is computer literate, but not programming/sql literate. David
-
With SQL Server Express, would it be possible to have it install with the application itself? The program is one I am writing for a friend of mine and isn't something I will be using. I wouldn't want a complicated install process or a hard way for them to move the database files if they had to change computers. My friend is computer literate, but not programming/sql literate. David
It is possible to include the SQL Express components as a dependency in your installation procedure.
Deja View - the feeling that you've seen this post before.
-
With SQL Server Express, would it be possible to have it install with the application itself? The program is one I am writing for a friend of mine and isn't something I will be using. I wouldn't want a complicated install process or a hard way for them to move the database files if they had to change computers. My friend is computer literate, but not programming/sql literate. David