Convenience Scripts - Oracle to SQL Server Migration

SQL scripts that can be helpful in Oracle to Microsoft SQL Server migration projects.

Built-in Functions

Emulating Oracle built-in functions in SQL Server:

INSTR - Find a position of substring in string

SQL Server Metadata

Select All Tables in All Databases (Transact-SQL Script)

Generating DROP Statements

Generate DROP TABLE scripts (With if exists check)

Data Cleansing

Correcting Trailing Spaces in Primary Keys

Workload Simulation

Inserting N Rows In a Loop Committing After Each Mth Row (Oracle PL/SQL and SQL Server Transact-SQL Scripts)