-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.

Improve this question
2
  • 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, 2016 at 11:46
  • do u know what SSMA is ?
    – shreya
    Mar 9, 2016 at 12:41

1 Answer 1

Reset to default
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.

Improve this answer
4
  • Hi , here is the download link: microsoft.com/en-in/download/details.aspx?id=43689
    – shreya
    Mar 14, 2016 at 6:53
  • @shreya that's what I expected. So my recommendation holds. Thoughts?
    – GregGalloway
    Mar 17, 2016 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, 2016 at 10:25
  • @shreya no clue. Open a support case I suppose
    – GregGalloway
    Mar 17, 2016 at 12:14

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .