Im currently running a website that needs integrating into multi channel sales software. In order to do this the website database needs upsizing/migrating from Access to MSSQl.
I have initially tried using 'SSMA for Access' to do this but from what I understand I need remote access to my SQL server which my hosting company won't grant. They have indicated that the database needs to be edited locally on my machine and a .sql dump saved and importing through the hosting package control panel interface. However, I do not know how to migrate/upsize the database locally?
If anybody has any ideas on how or what I should use do this, your information would be most appreciated.