That is to say: my clients are people without any technical knowledge and they usually communicate never with me.
Is SSE the correct database for this status, or should I use a desktop database like VFP or Access?
Once it's set up, it'll keep working indefinitely. You'll have to do most of the management in your software so the user can copy the database, for example.
The main limition with SQL Server Express is that you have to be sure to use an instance name that another applicaiton is unlikely to use, otherwise you'll have conflicts.
The main advantage of SQL Server Express versus something like Access is that you can easily move to the full-blown SQL Server Standard with virtually no effort.
-Ryan
|||It's a better approach to determine the needs of your application, both now and in the future, and then choose the right database engine to meet those needs. One alternative that hasn't been mentioned yet is SQL Compact Edition, which is similar to Access/Jet in that it is a file based, in process database engine. (Compared to SQL Express which is a service based engine.)
There is a paper at http://www.microsoft.com/sql/editions/compact/sscecomparison.mspx that attempts to clarify the differences between these platforms and why you would use one of the other. I generally think that you should start you planning at SQLce, since it offers a very light weight data engine that is easy to install and mange, and then work your way up the ladder if you discover application requriements that would prevent you from using it.
There is a forum dedicated to SQLce here on MSDN if you have questions about that database.
Mike
No comments:
Post a Comment