Hi
1) You have to upgrade to Autosys 12: it supports Autosys on Linux with SQL Server.
I think you have to upgrade first on Linux / Sybase, then by running the script CReateAEDB.pl, you will create database and schema on SQL Server.
2) I don't think there a tool to move from Sybase to SQL Server. The solution is to export all objects from AE-Sybase and insert them in AE-SQLserver
- jobs: autorep -q -j ALL > JOBS.jil
- machines: autorep -q -m ALL > MACHINES.jil
- resources: autorep -q -V ALL > RES.jil
- global variables: autorep -V ALL |awk '{print "sendevent -E SET_GLOBAL -G "$1"="$2}'
- std cal: autocal_asc -E std.cal -s ALL
- ext cal: autocal_asc -E ext.cal -e ALL
- cycle: autocal_asc -E cyc.txt -c ALL
You can also run autorep -J ALL to make a picture od job statuses and add the statuses of ON_HOLD / ON_ICE / ON_NO_EXEC / SUCCESS / FAILURE in JOBS.jil. Like that you will avoid running sendevent command after the jil insert.
Original Message:
Sent: 07-29-2020 10:16 AM
From: Ray Magliano
Subject: Migration of Sybase to SQL server
Hi,
I am running CA Workload Automation AE 11.3.6 sp7 on Linux. We are using Sybase as our database. I want to migrate off of Sybase to Sql Server.
Is there any documentation detailing the steps to take to do this?
Thanks,
Ray Magliano | Senior Manager
COG Technology | Macquarie Asset Management
2005 Market Street
Philadelphia, PA 19103 USA
T 1-215-255-2810 I M 1-215-287-9041 I E raymond.magliano@macquarie.com
WebEx: https://mgl.webex.com/join/raymond.magliano
www.macquarie.com
This email and any attachment is confidential. If you are not the intended recipient, please delete this message. Macquarie does not guarantee the integrity of any emails or attachments. For important disclosures and information about the incorporation and regulated status of Macquarie Group entities please see:
www.macquarie.com/disclosures