Migration from MS Access to MS SQL Server with SQL Server Migration Assistant.
MS SQL server needs to communicate with MS Access front-end via Internet.
MS Access >> Internet >> MS SQL Server
The database includes Japanese Language, so need to select "Japanese_CI_AS" as collation
in SQL Server.
Experience in migration in foreign language in the name of table and fields, such as Japanese, is required.
Rich experience in database experience required.
Remote migration using remote tools required.
The destination server is MS SQL Server on-premise VMware ESXi host.