Is there any easy way to copy data and schema from oracle to ms-sql. i am using sql server 2017 and oracle sql developer Version I need one time migration. I am using SSMA but getting connectivity error

enter image description here

  • Hi there, welcome to the site. Do you mean a one time migration or some sort of synchronization process? Are there any restrictions? Have you explored options but ran into problems? Please add as much detail as possible to your question so it can be answered without asking for too much clarification. Do so by editing your questions instead of adding clarifications in comments. – Tom V - Team Monica Nov 7 '18 at 15:16
  • If SSMA is the right tool (I don't know if this is the case) you should ask how to resolve the connection error. – miracle173 Nov 7 '18 at 17:38
  • I would suspect that the MS tool would be better suited for your purpose (as much I hate to say it). That said, a couple of observations. First, SQL Dev 4 is very old. The current version is 18. Second, the error you show has nothing to do with getting to MSSQL, you aren't even reaching your Oracle DB. Your connection definition (in SQL Dev) is incorrect. I can't say HOW it is incorrect or what needs to be adjusted, because we don't see that information. You'd need to show a screen shot of your connection properties to get started debugging. – EdStevens Nov 7 '18 at 22:32

You can use SQL Server Migration Assistant tool for Oracle. Details can be found here

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.