-1

I am facing the below error while syncing table from Oracle to an Azure SQL data warehouse using SSMA tool (a tool used to migrate data from Oracle to Azure SQL). I am able to connect to the database and convert the schema from Oracle database but, am getting an error while syncing it with the Azure SQL data warehouse. Please suggest a solution.

Errors: USE statement is not supported to switch between databases. Use a new connection to connect to a different Database.

Synchronization error: USE statement is not supported to switch between databases. Use a new connection to connect to a different Database.

I am unable to identify the rectification of this error in SSMA. Would help lots to know the resolution.

  • I'm no DBA, but it sounds to me like the USE statement isn't supported to switch between databases. I'd recommend using a new connection to connect to a different database. – HopelessN00b Mar 9 '16 at 11:46
  • do u know what SSMA is ? – shreya Mar 9 '16 at 12:41
1

I don't believe SSMA supports Azure SQL Data Warehouse. Can you provide a link to the download so everyone is clear which tool you are using?

What about an SSMA migration to a SQL Server 2014 Developer Edition instance, followed by using the Azure SQL Data Warehouse Migration Utility to migrate SQL to Azure SQL DW?

The two step migration is because SSMA doesn't support Azure SQL DW, and the Azure SQL DW Migration Utility doesn't yet support Oracle.

  • Hi , here is the download link: microsoft.com/en-in/download/details.aspx?id=43689 – shreya Mar 14 '16 at 6:53
  • @shreya that's what I expected. So my recommendation holds. Thoughts? – GregGalloway Mar 17 '16 at 1:08
  • thanks a lot that s a very good recommendation. I need your help regarding another issue with SSMA... My server side migration setting doesnt seem to work.. it fails without any error message. Any fix resolutions you can suggest to me? – shreya Mar 17 '16 at 10:25
  • @shreya no clue. Open a support case I suppose – GregGalloway Mar 17 '16 at 12:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.