SSMA provides flexibility for you to migrate your data with one of the two options below:
In order to enable server side data migration engine, you will need the following:
SSMA extension pack installation file comes in the SSMA download but requires separate installation:
The data migration operation is initiated from SQL Server through a SQL Agent job.
Note that SSMA provides a warning when connecting to target when SQL Server Agent is not running: "Common Requirement: SQL Server Agent is not running. You must start SQL Server Agent to use Server-side data migration engine". You can ignore this warning if you do not plan to perform data migration or if you decide to use client side data migration engine.
You can set the data migration option through the project setting:
I am currently working in project where we need to migrate/point batch jobs,Access(.MDB) files, Sybase Stored procs and Tables to SQL server 2005.
At this moment they are pointing to Sybase. Batch jobs are in .bat and .exe format. These jobs read in an external file, does some reformatting, and then loads it into 2 sybase tables. These jobs are auto scheduled through Control-M application.
Any idea please ?