Ispirer Website
Ispirer Capabilities: Microsoft SQL Server Migration
Free Trial
As for Microsoft SQL Server, SQLWays utility uses select statements to system tables and views to extract information about the source DDL for all the objects that need to be converted. So, we need to create a login with a default database where objects required for the migration are stored. Create a user for this login and assign the following privileges that are required to support the export for Microsoft SQL Server objects:
Privileges that should be assigned to the user:
OR
You can just add your login to a sysadmin role EXEC master..sp_addsrvrolemember @loginame = N'sql_test', @rolename = N'sysadmin'.
If you have any other questions, please contact us: support@ispirer.com