SSMA Oracle Migration to SQL Server - Automation

Rob Stevens 1 Reputation point
2020-11-18T21:54:26.577+00:00

Hi
We're looking at using SSMA to do a regular build of a SQL Server database from an Oracle database for a client datawarehouse team. I've been able to set this up using SSMA and run it using the application. I'm now looking at automating this using the command line switches.
Anyone have experience with this? Ideally I'd like to just open the existing project (which already has all the tables I want to extract) and then trigger the migrate and then close the project.
Is this possible?
Regards
Rob

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
532 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alexander Ivanov 491 Reputation points
    2020-12-04T06:04:44.007+00:00

    Hello,

    Yes, this should be doable. SSMA has a console version, which is documented here. Take a look at sample script files, in particular ConversionAndDataMigrationSample.xml. You will be using open-project, connect/reconnect-source/target-database and migrate-data commands.

    Regards,
    Alex.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.