Can I transfer Access 2010 databases to the SQL 2019 express server?

Question

Hi,

Currently I have big issue.

In work I have 7 Access databases and around 70 users.

We collect a lot of data every month. This data is a base for many reports.

Can I transfer this access databases to the SQL 2019 Express ?

Second issue, all this Access databases have front end from the WinForms.

I need move all functionality too.

Please let me know or advice this is possible?

If yes, please advice how can I do this.

Best wishes

Krzysztof

Answer 1

Yes. You should be able to upsize your BE tables from A2010 to SQL Server 2019 Express.

For best performance you should also move most of your queries to SS as views or stored procedures.

I'm not clear what you mean by Winforms but as your FE forms, reports & code will stay in Access FEs, there should be no problem 

Answer 2

You can use the already mention UpSize tool of MS Access

Or you can use the free MS tool SSMA = SQL Server Migration Assistant for Access (AccessToSQL)

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 3

For info, in Access 2010 the upsizing wizard is under Move Data ...SQL Server on the Database Tools ribbon.

However that feature was deprecated in later versions.

The SS Migration Assistant (SSMA) mentioned above is much more powerful & I would suggest you use that in preference.

Answer 4

Re WinForms: that is a .NET technology to create desktop applications.

At the very least you would have to change your Winforms connection string. The rest depends on too many finer points, and is off-topic for this Access forum anyway.

---

-Tom. Microsoft Access MVP

Answer 5

Tom

Thanks for the info on WinForms

Answer 6

Hello Guys,

Thank you for your time and advice. I will be this week test the first transition of the database.
Please finger cross.
I will inform you about the progress and problems.

Best regards,

Krzysztof

Answer 7

Hi Guys,

Thank you for your time and advice. I will be this week test the first transition of the database.
Please finger cross.
I will inform you about the progress and problems.

Best regards,

Krzysztof