Convenience Scripts - Oracle to SQL Server Migration

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

Emulating Oracle built-in functions in SQL Server:

• INSTR - Find a position of substring in string

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

• Generate DROP TABLE scripts (With if exists check)

• Correcting Trailing Spaces in Primary Keys

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