This is a migrated thread and some comments may be shown as answers.

Recommended database back end?

1 Answer 32 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Keith
Top achievements
Rank 1
Keith asked on 10 Nov 2011, 07:57 PM
I'm writing a desktop app that will be used on a single machine, single user (at a time).

It will need a database but the data is never likely to get beyond 100,000 records.

Any recommendations on a back end database?

I'm pretty familiar with SQL Server, so would SQL Server Express be good?

If so, how does that work? Does the SSExpress app need to be running before my app can access it? Or, does the act of accessing the data sufficient?

Thanks in advance for your help.

1 Answer, 1 is accepted

Sort by
0
Svett
Telerik team
answered on 15 Nov 2011, 09:29 AM
Hi Keith,

The most efficient in cost and performance for this scenario is Microsoft SQL Express. It is free and performs very well in a single user scenario. You should install it and run it before you try to connect to the server. Also, it supports data base attaching by the client on demand. You can read more about this feature in this MSDN article. You can compare the different SQL Server editions here.

All the best,
Svett
the Telerik team

Q2’11 SP1 of RadControls for WinForms is available for download (see what's new); also available is the Q3'11 Roadmap for Telerik Windows Forms controls.

Tags
General Discussions
Asked by
Keith
Top achievements
Rank 1
Answers by
Svett
Telerik team
Share this question
or