Database for Inventory System in C #

Question

I am updating the inventory system for a jewllery store that was originally built using MS Access. The application stores items, customers, suppliers and displays data about stored items. A reporting tool should be considered to generate reports for items in print.

The system should be built in C #, but I have not yet made a decision for the database engine that I have to use for this application. What do you suggest?. I was thinking about SQLite, but I need to keep in mind that migration elements from the old database to the new updated information are required. And since it was originally built with MS Access. Should I just stick with MS Access and create my own application with it?

Edit: This is a separate user system.

Answer 1

For single-user desktop applications in the Microsoft ecosystem, consider SQL Server Compact Edition , not a full-fledged server product. The following is part of the Microsoft review:

Microsoft SQL Server 2005 Compact (SQL Server Compact Edition) , , , , . SQL Server Compact Runtime .

SQL Server Compact Edition - , , (SQL) API SQL Server.

(, ) ( , ).

SO, Access SQL Server CE, .

Answer 2

SQL Server Express - , MS. , - DB (, ), , DTS, SSIS, , .

Answer 3

#, Sql Server ; MySql .

MS-Access SqlLite ; / - . .

Answer 4

. , ( 5).

• ?
• ?
• , ?
• ?

. . SQL- MySQL ( ). Oracle, , , , .

[]

SQL Server Express http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=b448b0d0-ee79-48f6-b50a-7c4f028c2e3d. - . , 4 - . , .

Answer 5

PostgreSQL, http://www.postgresql.org/

It is free, fast, and has providers for .NET.

Answer 6

Sql Server, then you can add reporting services, and the transition path from access should be simple. You can even start with the release of Express.