Script for renaming indexes in the migrated database

RENAME satpms_id_SEQ TO satpms_SEQ;
RENAME development_teams_id_SEQ TO development_teams_SEQ;
RENAME tasks_id_SEQ TO tasks_SEQ;
RENAME export_import_sessions_id_SEQ TO export_import_sessions_SEQ;
RENAME integration_csv_data_id_SEQ TO integration_csv_data_SEQ;
RENAME server_groups_id_SEQ TO server_groups_SEQ;
RENAME messages_id_SEQ TO messages_SEQ;
RENAME lifecycle_members_id_SEQ TO lifecycle_members_SEQ;
RENAME server_level_properties_id_SEQ TO server_level_properties_SEQ;
RENAME integration_csvs_id_SEQ TO integration_csvs_SEQ;
RENAME lifecycle_stage_statuses_id_SE TO lifecycle_stage_statuses_SEQ;
RENAME steps_release_content_items_id TO steps_release_content_item_SEQ;
RENAME requests_id_SEQ TO requests_SEQ;
RENAME user_groups_id_SEQ TO user_groups_SEQ;
RENAME groups_id_SEQ TO groups_SEQ;
RENAME servers_id_SEQ TO servers_SEQ;
RENAME application_components_id_SEQ TO application_components_SEQ;
RENAME temporary_property_values_id_S TO temporary_property_values_SEQ;
RENAME components_id_SEQ TO components_SEQ;
RENAME grouped_environments_id_SEQ TO grouped_environments_SEQ;
RENAME scripts_id_SEQ TO scripts_SEQ;
RENAME package_contents_id_SEQ TO package_contents_SEQ;
RENAME lifecycle_environments_id_SEQ TO lifecycle_environments_SEQ;
RENAME server_aspect_groups_id_SEQ TO server_aspect_groups_SEQ;
RENAME release_content_items_id_SEQ TO release_content_items_SEQ;
RENAME query_details_id_SEQ TO query_details_SEQ;
RENAME lifecycle_templates_id_SEQ TO lifecycle_templates_SEQ;
RENAME environment_roles_id_SEQ TO environment_roles_SEQ;
RENAME package_template_components_id TO package_template_component_SEQ;
RENAME lifecycle_wikis_id_SEQ TO lifecycle_wikis_SEQ;
RENAME steps_id_SEQ TO steps_SEQ;
RENAME environment_servers_id_SEQ TO environment_servers_SEQ;
RENAME list_items_id_SEQ TO list_items_SEQ;
RENAME integration_projects_id_SEQ TO integration_projects_SEQ;
RENAME releases_id_SEQ TO releases_SEQ;
RENAME teams_groups_id_SEQ TO teams_groups_SEQ;
RENAME step_script_arguments_id_SEQ TO step_script_arguments_SEQ;
RENAME activity_index_columns_id_SEQ TO activity_index_columns_SEQ;
RENAME budget_import_logs_id_SEQ TO budget_import_logs_SEQ;
RENAME property_values_id_SEQ TO property_values_SEQ;
RENAME activity_attributes_id_SEQ TO activity_attributes_SEQ;
RENAME temporary_budget_line_items_id TO temporary_budget_line_item_SEQ;
RENAME audits_id_SEQ TO audits_SEQ;
RENAME system_settings_id_SEQ TO system_settings_SEQ;
RENAME apps_business_processes_id_SEQ TO apps_business_processes_SEQ;
RENAME activity_notes_id_SEQ TO activity_notes_SEQ;
RENAME server_levels_id_SEQ TO server_levels_SEQ;
RENAME lifecycle_apps_id_SEQ TO lifecycle_apps_SEQ;
RENAME activity_categories_id_SEQ TO activity_categories_SEQ;
RENAME environments_id_SEQ TO environments_SEQ;
RENAME chat_logs_id_SEQ TO chat_logs_SEQ;
RENAME lifecycles_id_SEQ TO lifecycles_SEQ;
RENAME lifecycle_stages_id_SEQ TO lifecycle_stages_SEQ;
RENAME bladelogic_scripts_id_SEQ TO bladelogic_scripts_SEQ;
RENAME apps_id_SEQ TO apps_SEQ;
RENAME server_aspects_id_SEQ TO server_aspects_SEQ;
RENAME users_id_SEQ TO users_SEQ;
RENAME recent_activities_id_SEQ TO recent_activities_SEQ;
RENAME security_answers_id_SEQ TO security_answers_SEQ;
RENAME user_apps_id_SEQ TO user_apps_SEQ;
RENAME activity_tab_attributes_id_SEQ TO activity_tab_attributes_SEQ;
RENAME categories_id_SEQ TO categories_SEQ;
RENAME activity_tabs_id_SEQ TO activity_tabs_SEQ;
RENAME lc_stages_request_templates_id TO lc_stages_request_template_SEQ;
RENAME activity_deliverables_id_SEQ TO activity_deliverables_SEQ;
RENAME project_servers_id_SEQ TO project_servers_SEQ;
RENAME workstreams_id_SEQ TO workstreams_SEQ;
RENAME assets_id_SEQ TO assets_SEQ;
RENAME release_contents_id_SEQ TO release_contents_SEQ;
RENAME teams_id_SEQ TO teams_SEQ;
RENAME bladelogic_users_id_SEQ TO bladelogic_users_SEQ;
RENAME business_processes_id_SEQ TO business_processes_SEQ;
RENAME package_template_items_id_SEQ TO package_template_items_SEQ;
RENAME properties_id_SEQ TO properties_SEQ;
RENAME request_package_contents_id_SE TO request_package_contents_SEQ;
RENAME build_contents_id_SEQ TO build_contents_SEQ;
RENAME transaction_logs_id_SEQ TO transaction_logs_SEQ;
RENAME notes_id_SEQ TO notes_SEQ;
RENAME app_environment_groups_id_SEQ TO app_environment_groups_SEQ;
RENAME integration_releases_id_SEQ TO integration_releases_SEQ;
RENAME component_templates_id_SEQ TO component_templates_SEQ;
RENAME step_execution_conditions_id_S TO step_execution_conditions_SEQ;
RENAME request_templates_id_SEQ TO request_templates_SEQ;
RENAME email_recipients_id_SEQ TO email_recipients_SEQ;
RENAME export_logs_id_SEQ TO export_logs_SEQ;
RENAME delayed_jobs_id_SEQ TO delayed_jobs_SEQ;
RENAME capistrano_scripts_id_SEQ TO capistrano_scripts_SEQ;
RENAME budget_line_items_id_SEQ TO budget_line_items_SEQ;
RENAME activity_logs_id_SEQ TO activity_logs_SEQ;
RENAME queries_id_SEQ TO queries_SEQ;
RENAME lists_id_SEQ TO lists_SEQ;
RENAME phases_id_SEQ TO phases_SEQ;
RENAME teams_users_id_SEQ TO teams_users_SEQ;
RENAME activity_attribute_values_id_S TO activity_attribute_values_SEQ;
RENAME lifecycle_activities_id_SEQ TO lifecycle_activities_SEQ;
RENAME activity_phases_id_SEQ TO activity_phases_SEQ;
RENAME step_holders_id_SEQ TO step_holders_SEQ;
RENAME service_now_data_id_SEQ TO service_now_data_SEQ;
RENAME application_environments_id_SE TO application_environments_SEQ;
RENAME environment_groups_id_SEQ TO environment_groups_SEQ;
RENAME change_requests_id_SEQ TO change_requests_SEQ;
RENAME notification_templates_id_SEQ TO notification_templates_SEQ;
RENAME teams_roles_id_SEQ TO teams_roles_SEQ;
RENAME containers_id_SEQ TO containers_SEQ;
RENAME capistrano_script_arguments_id TO capistrano_script_argument_SEQ;
RENAME job_runs_id_SEQ TO job_runs_SEQ;
RENAME lifecycle_stage_dates_id_SEQ TO lifecycle_stage_dates_SEQ;
RENAME property_tasks_id_SEQ TO property_tasks_SEQ;
RENAME procedures_id_SEQ TO procedures_SEQ;
RENAME activities_id_SEQ TO activities_SEQ;
RENAME script_arguments_id_SEQ TO script_arguments_SEQ;
RENAME bladelogic_script_arguments_id TO bladelogic_script_argument_SEQ;
RENAME assigned_environments_id_SEQ TO assigned_environments_SEQ;
RENAME apps_requests_id_SEQ TO apps_requests_SEQ;
RENAME runtime_phases_id_SEQ TO runtime_phases_SEQ;
RENAME integrations_id_SEQ TO integrations_SEQ;
RENAME default_tabs_id_SEQ TO default_tabs_SEQ;
RENAME assigned_apps_id_SEQ TO assigned_apps_SEQ;
RENAME resource_allocations_id_SEQ TO resource_allocations_SEQ;
RENAME component_properties_id_SEQ TO component_properties_SEQ;
RENAME integration_csv_columns_id_SEQ TO integration_csv_columns_SEQ;
RENAME installed_components_id_SEQ TO installed_components_SEQ;
RENAME bladelogic_roles_id_SEQ TO bladelogic_roles_SEQ;
RENAME parent_activities_id_SEQ TO parent_activities_SEQ;
RENAME activity_creation_attributes_i TO aca_SEQ;
RENAME package_templates_id_SEQ TO package_templates_SEQ;
RENAME lifecycle_teams_id_SEQ TO lifecycle_teams_SEQ;
RENAME preferences_id_SEQ TO preferences_SEQ;
RENAME calendar_reports_id_SEQ TO calendar_reports_SEQ;

ALTER TABLE ENVIRONMENTS RENAME COLUMN DEFAULT_ TO "DEFAULT";
ALTER TABLE APPS RENAME COLUMN DEFAULT_ TO "DEFAULT";