jeudi 8 janvier 2015

Is SQL written for SQLite interchangeable with SQL for an Access database?

I have written a project in C# which currently uses a SQLite database with 7 tables. Now I made a little mistake in selecting my database and since the application is going to be accessed by multiple users (~100) on a network the SQLite solution won't work because only one user can write at a time.


Now I want to switch to an Access (2010) database but my question is: If I create the Access database with the same scheme as my SQLite database, do I have to change any of the SQL statements that I have written in my application? Or does this work interchangeable?


Also some side notes of why I am switching to an Access database instead of something like a SQL Server... Time does not allow this and costs neither.


Can anyone tell me what the impact will be if I'd simply replace the SQLite database with the Access database. OR if anyone has any other suggestions, they are more than welcome!


Thanks in advance!


Aucun commentaire:

Enregistrer un commentaire