Emulating Records and Collections via CLR UDT

re: Emulating Records and Collections via CLR UDT

Angshuman Nayak — Mon, 18 Feb 2013 05:17:12 GMT

Hi Scott,

This is not a special installation rather it's a part of the SSMA installation itself which unzips into to two distinct exe files. In the download section of SSMA we have explicitly mentioned this.

"This download includes a GUI client based application to manage migration process as well as SSMA extension pack to be installed on target SQL Server. SSMA extension pack includes functionalities to emulate Oracle features not natively supported in SQL server, tester database to support SSMA Testing features, and an application to facilitate direct server-to-server data migration. "

So the steps are part of the "pure" solution. We do this so that we provide the same Oracle features that are not natively supported in SQL Server. This helps in porting your application without major changes.

You can find details at : msdn.microsoft.com/.../hh313165.aspx

re: Emulating Records and Collections via CLR UDT

Scott Lewis — Fri, 15 Feb 2013 20:08:27 GMT

Thanks Angshuman.

Deciding to go a different route. We want a "pure" solution, so we don't have to do any special installations on each target database.

Cheers.

re: Emulating Records and Collections via CLR UDT

Angshuman Nayak — Fri, 15 Feb 2013 03:33:47 GMT

Hi Scott,

Have you installed the SSMA for Oracle Extension Pack? This is a separate installation than the SSMA executable itself and is the one that will deploy the CLR assemblies and create the CLR based UDTs on the on target SQL Server. This has functionalities to emulate Oracle features not natively supported in SQL server.

Please test that out and leave a comment on the results.

Angshuman Nayak

re: Emulating Records and Collections via CLR UDT

Scott Lewis — Thu, 14 Feb 2013 23:32:51 GMT

From the white paper:

SSMA creates three CLR-based UDTs:

• CollectionIndexInt

• CollectionIndexString

• Record

For some reason, unknown to me, these TYPES have not been created when running SSMA and then many of my conversions fail with "Cannot find data type dbo.CollectionIndexInt"

How do I get SSMA to create the types or how do I create them myself?