Transact-SQL (TSQL) Migration Guide

Migrate Transact-SQL applications, schemas, stored procedures, and data to InterSystems IRIS.

Updated Feb 2, 2026

Search Tags:#database #migration #sql #tsql #mssql #intersystems iris #sybase

Ready to run

npx skills add https://github.com/sorodriguezz/skills-objectscript --skill transact-sql-tsql-migration-guide

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: Transact-SQL (TSQL) Migration Guide
Source: https://github.com/sorodriguezz/skills-objectscript/tree/main/skills/transact-sql-tsql-migration-guide
Command: npx skills add https://github.com/sorodriguezz/skills-objectscript --skill transact-sql-tsql-migration-guide

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides a comprehensive guide for migrating Transact-SQL (TSQL) applications, including schemas, stored procedures, and data, to the InterSystems IRIS data platform.

Core Features & Use Cases

Migration Planning: Offers detailed steps for planning infrastructure, reviewing application code and schema, and assessing data.
Execution Guidance: Outlines procedures for configuring InterSystems IRIS, migrating code and data, and troubleshooting.
TSQL on IRIS: Explains how to write and execute TSQL code within the InterSystems IRIS environment using various interfaces.
Use Case: A database administrator needs to migrate a Sybase ASE TSQL application to InterSystems IRIS. This guide will walk them through the entire process, from initial planning to final execution and testing.

Quick Start

Use the transact-sql-tsql-migration-guide skill to understand the steps for migrating a TSQL application to InterSystems IRIS.

Frequently Asked Questions about Transact-SQL (TSQL) Migration Guide

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I migrate a TSQL database to InterSystems IRIS?▼

Migrating a TSQL database to InterSystems IRIS involves planning infrastructure, reviewing application code and schema, configuring IRIS, and executing code and data migration. This guide provides detailed steps for the entire process.

Can I run Sybase ASE stored procedures on InterSystems IRIS?▼

Yes, you can execute Sybase ASE TSQL stored procedures on InterSystems IRIS. The platform supports running TSQL code using various SQL interfaces and class definitions within the InterSystems IRIS environment.

What is the process for migrating Microsoft TSQL schemas to InterSystems IRIS?▼

Migrating Microsoft TSQL schemas to InterSystems IRIS involves assessing your existing data structures, reviewing application code, and configuring the target IRIS environment before executing the schema and data migration.

Does InterSystems IRIS support both Sybase and Microsoft TSQL dialects?▼

Yes, InterSystems IRIS supports both Sybase and Microsoft TSQL dialects. The platform allows you to write and execute TSQL code through SQL interfaces and class definitions for migrated applications.

What should I check before migrating TSQL applications to InterSystems IRIS?▼

Before TSQL migration, you should plan your infrastructure setup, review your application code and database schema, and assess your data. This guide walks you through the required preparatory steps.