View a markdown version of this page

Built-in function and system object rules - AWS Database Migration Service

Built-in function and system object rules

DMS Schema Conversion applies default rules to convert Microsoft SQL Server built-in functions and system objects when it converts a source schema to Amazon Aurora PostgreSQL or Amazon RDS for PostgreSQL. The following sections list the source objects in each category and show how DMS Schema Conversion converts each one.

Each table uses the following columns:

  • Source – the SQL Server built-in function or system object.

  • Conversion – how DMS Schema Conversion converts the object. A value of Same name means a direct mapping, Renamed means the object maps to a target with a different name, Rewritten means DMS Schema Conversion rewrites the object as a target expression, Extension pack means the conversion uses a function from the DMS Schema Conversion extension pack, and Not converted means DMS Schema Conversion does not convert the object automatically.

  • Target – the target object or expression that DMS Schema Conversion produces.

  • Action item – the action item code that DMS Schema Conversion reports for the object. An action item can mean that the object needs manual work, or be informational about an object that DMS Schema Conversion converted.

Terms used in this topic

The following table defines the terms that describe each conversion outcome.

Term Meaning
Same name Converted automatically to a target object of the same name.
Renamed Converted automatically to a differently named target equivalent.
Rewritten Replaced by an equivalent native expression.
Extension pack DMS Schema Conversion converts the call to a function in the AWS DMS extension pack, a helper schema that emulates source functions with no PostgreSQL equivalent (aws_oracle_ext for Oracle sources, aws_sqlserver_ext for SQL Server sources). Apply the extension pack to your target database before you run the converted code.
Not converted No automatic conversion. An action item is raised and the code needs manual work.

Aggregate

The following table lists each source object in the Aggregate category and shows how DMS Schema Conversion converts it.

SourceConversionTargetAction item
AVGSame nameAVGNone
CHECKSUM_AGGNot convertedNot applicable7811: PostgreSQL doesn't support the CHECKSUM_AGG function. DMS SC skips this unsupported function in the converted code
COUNTSame nameCOUNTNone
COUNT_BIGRenamedCOUNTNone
GROUPING_IDNot convertedNot applicable7811: PostgreSQL doesn't support the GROUPING_ID function. DMS SC skips this unsupported function in the converted code
MAXSame nameMAXNone
MINSame nameMINNone
STDEVRenamedSTDDEV_SAMPNone
STDEVPRenamedSTDDEV_POPNone
SUMSame nameSUMNone
VARRenamedVAR_SAMPNone
VARPRenamedVAR_POPNone

Account and profiles

The following table lists each source object in the Account and profiles category and shows how DMS Schema Conversion converts it.

SourceConversionTargetAction item
MSDB.DBO.SYSMAIL_ADD_ACCOUNT_SPExtension packaws_sqlserver_ext.SYSMAIL_ADD_ACCOUNT_SPNone
MSDB.DBO.SYSMAIL_ADD_PROFILEACCOUNT_SPExtension packaws_sqlserver_ext.SYSMAIL_ADD_PROFILEACCOUNT_SPNone
MSDB.DBO.SYSMAIL_ADD_PROFILE_SPExtension packaws_sqlserver_ext.SYSMAIL_ADD_PROFILE_SPNone
MSDB.DBO.SYSMAIL_DELETE_ACCOUNT_SPExtension packaws_sqlserver_ext.SYSMAIL_DELETE_ACCOUNT_SPNone
MSDB.DBO.SYSMAIL_DELETE_PROFILEACCOUNT_SPExtension packaws_sqlserver_ext.SYSMAIL_DELETE_PROFILEACCOUNT_SPNone
MSDB.DBO.SYSMAIL_DELETE_PROFILE_SPExtension packaws_sqlserver_ext.SYSMAIL_DELETE_PROFILE_SPNone
MSDB.DBO.SYSMAIL_HELP_ACCOUNT_SPExtension packaws_sqlserver_ext.SYSMAIL_HELP_ACCOUNT_SPNone
MSDB.DBO.SYSMAIL_HELP_PROFILEACCOUNT_SPExtension packaws_sqlserver_ext.SYSMAIL_HELP_PROFILEACCOUNT_SPNone
MSDB.DBO.SYSMAIL_HELP_PROFILE_SPExtension packaws_sqlserver_ext.SYSMAIL_HELP_PROFILE_SPNone
MSDB.DBO.SYSMAIL_UPDATE_ACCOUNT_SPExtension packaws_sqlserver_ext.SYSMAIL_UPDATE_ACCOUNT_SPNone
MSDB.DBO.SYSMAIL_UPDATE_PROFILEACCOUNT_SPExtension packaws_sqlserver_ext.SYSMAIL_UPDATE_PROFILEACCOUNT_SPNone
MSDB.DBO.SYSMAIL_UPDATE_PROFILE_SPExtension packaws_sqlserver_ext.SYSMAIL_UPDATE_PROFILE_SPNone
MSDB.DBO.SYSMAIL_VERIFY_ACCOUNT_SPNot convertedNot applicable7900: PostgreSQL doesn't support functionality similar to SQL Server Database Mail
MSDB.DBO.SYSMAIL_VERIFY_ADDRESSPARAMS_SPNot convertedNot applicable7900: PostgreSQL doesn't support functionality similar to SQL Server Database Mail
MSDB.DBO.SYSMAIL_VERIFY_PROFILE_SPNot convertedNot applicable7900: PostgreSQL doesn't support functionality similar to SQL Server Database Mail

Configuration functions

The following table lists each source object in the Configuration functions category and shows how DMS Schema Conversion converts it.

SourceConversionTargetAction item
@@DATEFIRSTNot convertedNot applicable7811: PostgreSQL doesn't support the @@DATEFIRST function. DMS SC skips this unsupported function in the converted code
@@DBTSRewrittenINT8SEND(PG_SNAPSHOT_XMAX(PG_CURRENT_SNAPSHOT())::TEXT::BIGINT-1)None
@@LANGIDNot convertedNot applicable7811: PostgreSQL doesn't support the @@LANGID function. DMS SC skips this unsupported function in the converted code
@@LANGUAGENot convertedNot applicable7811: PostgreSQL doesn't support the @@LANGUAGE function. DMS SC skips this unsupported function in the converted code
@@LOCK_TIMEOUTNot convertedNot applicable7811: PostgreSQL doesn't support the @@LOCK_TIMEOUT function. DMS SC skips this unsupported function in the converted code
@@MAX_CONNECTIONSNot convertedNot applicable7811: PostgreSQL doesn't support the @@MAX_CONNECTIONS function. DMS SC skips this unsupported function in the converted code
@@MAX_PRECISIONNot convertedNot applicable7811: PostgreSQL doesn't support the @@MAX_PRECISION function. DMS SC skips this unsupported function in the converted code
@@NESTLEVELNot convertedNot applicable7811: PostgreSQL doesn't support the @@NESTLEVEL function. DMS SC skips this unsupported function in the converted code
@@OPTIONSNot convertedNot applicable7811: PostgreSQL doesn't support the @@OPTIONS function. DMS SC skips this unsupported function in the converted code
@@REMSERVERNot convertedNot applicable7811: PostgreSQL doesn't support the @@REMSERVER function. DMS SC skips this unsupported function in the converted code
@@SERVERNAMENot convertedNot applicable7811: PostgreSQL doesn't support the @@SERVERNAME function. DMS SC skips this unsupported function in the converted code
@@SERVICENAMENot convertedNot applicable7811: PostgreSQL doesn't support the @@SERVICENAME function. DMS SC skips this unsupported function in the converted code
@@SPIDRenamedpg_backend_pid()None
@@TEXTSIZENot convertedNot applicable7811: PostgreSQL doesn't support the @@TEXTSIZE function. DMS SC skips this unsupported function in the converted code
@@VERSIONNot convertedNot applicable7811: PostgreSQL doesn't support the @@VERSION function. DMS SC skips this unsupported function in the converted code

Cursor functions

The following table lists each source object in the Cursor functions category and shows how DMS Schema Conversion converts it.

SourceConversionTargetAction item
@@CURSOR_ROWSNot convertedNot applicable7811: PostgreSQL doesn't support the @@CURSOR_ROWS function. DMS SC skips this unsupported function in the converted code
@@FETCH_STATUSRewritten(case FOUND::int when 0 then -1 else 0 end)None

Date and time

The following table lists each source object in the Date and time category and shows how DMS Schema Conversion converts it.

SourceConversionTargetAction item
CURRENT_TIMESTAMPRewrittenCURRENT_TIMESTAMP(3)None
DATEADD(DAY / DD / D, …)Rewritten⟨date⟩ + (⟨number⟩::numeric || ' DAY')::intervalNone
DATEADD(DAYOFYEAR / DY / Y, …)Rewritten⟨date⟩ + (⟨number⟩::numeric || ' DAY')::intervalNone
DATEADD(HOUR / HH, …)Rewritten⟨date⟩ + (⟨number⟩::numeric || ' HOUR')::intervalNone
DATEADD(MICROSECOND / MCS, …)Rewritten⟨date⟩ + (⟨number⟩::numeric || ' MICROSECOND')::intervalNone
DATEADD(MILLISECOND / MS, …)Rewritten⟨date⟩ + (⟨number⟩::numeric || ' MILLISECOND')::intervalNone
DATEADD(MINUTE / MI / N, …)Rewritten⟨date⟩ + (⟨number⟩::numeric || ' MINUTE')::intervalNone
DATEADD(MONTH / MM / M, …)Rewritten⟨date⟩ + (⟨number⟩::numeric || ' MONTH')::intervalNone
DATEADD(NANOSECOND / NS, …)Not convertedNot applicable7811: PostgreSQL doesn't support the DATEADD(NANOSECOND / NS, …) function. DMS SC skips this unsupported function in the converted code
DATEADD(QUARTER / QQ / Q, …)Rewritten⟨date⟩ + (⟨number⟩::numeric * 3 || ' MONTH')::intervalNone
DATEADD(SECOND / SS / S, …)Rewritten⟨date⟩ + (⟨number⟩::numeric || ' SECOND')::intervalNone
DATEADD(WEEK / WK / WW, …)Rewritten⟨date⟩ + (⟨number⟩::numeric || ' WEEK')::intervalNone
DATEADD(WEEKDAY / DW, …)Rewritten⟨date⟩ + (⟨number⟩::numeric || ' DAY')::intervalNone
DATEADD(YEAR / YYYY / YY, …)Rewritten⟨date⟩ + (⟨number⟩::numeric || ' YEAR')::intervalNone
DATEADD(…) in an unsupported date arithmetic expressionNot convertedNot applicable7774: DMS SC can't convert arithmetic operations with mixed types of operands
DATEDIFFExtension packaws_sqlserver_ext.datediff('day',⟨startdate⟩::TIMESTAMP,⟨enddate⟩::TIMESTAMP)None
DATEFROMPARTSRenamedmake_dateNone
DATENAME(DAY / DD / D, …)Rewrittencast(date_part('day',⟨date⟩::DATE) as varchar(2))None
DATENAME(DAYOFYEAR / DY / Y, …)Rewrittento_char(⟨date⟩::DATE,'DDD')None
DATENAME(HOUR / HH, …)Rewrittencast(date_part('H',⟨date⟩::TIMESTAMP) as varchar(2))None
DATENAME(MICROSECOND / MCS, …)Rewrittencast(cast(to_char(⟨date⟩::TIMESTAMP,'US') as int) as varchar(6))None
DATENAME(MILLISECOND / MS, …)Rewrittencast(cast(to_char(⟨date⟩::TIMESTAMP,'MS') as int) as varchar(3))None
DATENAME(MINUTE / N, …)Rewrittencast(date_part('minute',⟨date⟩::TIMESTAMP) as varchar(2))None
DATENAME(MONTH / MM / M, …)Rewrittento_char(⟨date⟩::DATE,'Month')None
DATENAME(NANOSECOND / NS, …)Not convertedNot applicable7811: PostgreSQL doesn't support the DATENAME(NANOSECOND / NS, …) function. DMS SC skips this unsupported function in the converted code
DATENAME(QUARTER / QQ / Q, …)Rewrittento_char(⟨date⟩::DATE,'q')None
DATENAME(SECOND / SS / S, …)Rewrittencast(cast(to_char(⟨date⟩::TIMESTAMP,'SS') as int) as varchar(2))None
DATENAME(TZOFFSET / TZ, …)Rewrittento_char(⟨date⟩::TIMESTAMP,'OF')None
DATENAME(WEEK / WK / WW, …)Rewrittencast(date_part('week',⟨date⟩::DATE) as varchar(2))None
DATENAME(WEEKDAY / DW, …)Rewrittento_char(⟨date⟩::TIMESTAMP,'Day')None
DATENAME(YEAR / YYYY / YY, …)Rewrittento_char(⟨date⟩::DATE,'YYYY')None
DATEPART(DAY / DD / D, …)Rewrittendate_part('day',⟨date⟩::TIMESTAMP)None
DATEPART(DAYOFYEAR / DY / Y, …)Rewrittencast(to_char(⟨date⟩::TIMESTAMP,'DDD') as int)None
DATEPART(HOUR / HH, …)Rewrittendate_part('H',⟨date⟩::TIMESTAMP)None
DATEPART(ISO_WEEK / ISOWK / ISOWW, …)RewrittenEXTRACT(WEEK FROM ⟨date⟩)None
DATEPART(MICROSECOND / MCS, …)Rewrittencast(to_char(⟨date⟩::TIMESTAMP,'US') as int)None
DATEPART(MILLISECOND / MS, …)Rewrittencast(to_char(⟨date⟩::TIMESTAMP,'MS') as int)None
DATEPART(MINUTE / MI / N, …)Rewrittendate_part('minute',⟨date⟩::TIMESTAMP)None
DATEPART(MONTH / MM / M, …)Rewrittendate_part('month',⟨date⟩::TIMESTAMP)None
DATEPART(NANOSECOND / NS, …)Not convertedNot applicable7811: PostgreSQL doesn't support the DATEPART(NANOSECOND / NS, …) function. DMS SC skips this unsupported function in the converted code
DATEPART(QUARTER / QQ / Q, …)Rewrittendate_part('quarter',⟨date⟩::TIMESTAMP)None
DATEPART(SECOND / SS / S, …)Rewrittencast(to_char(⟨date⟩::TIMESTAMP,'SS') as int)None
DATEPART(TZOFFSET / TZ, …)Not convertedNot applicable7811: PostgreSQL doesn't support the DATEPART(TZOFFSET / TZ, …) function. DMS SC skips this unsupported function in the converted code
DATEPART(WEEK / WK / WW, …)Rewrittencast(to_char(⟨date⟩::TIMESTAMP, 'WW') as int)None
DATEPART(WEEKDAY / DW, …)Rewrittencast(to_char(⟨date⟩::TIMESTAMP,'D') as int)None
DATEPART(YEAR / YYYY / YY, …)Rewrittendate_part('year',⟨n⟩::TIMESTAMP)None
DATETIME2FROMPARTSExtension packaws_sqlserver_ext.datetime2fromparts(⟨y⟩, ⟨m⟩, ⟨d⟩, ⟨h⟩, ⟨min⟩, ⟨sec⟩, ⟨frc⟩, ⟨prcn⟩)None
DATETIMEFROMPARTSExtension packaws_sqlserver_ext.datetimefromparts(⟨y⟩, ⟨m⟩, ⟨d⟩, ⟨h⟩, ⟨min⟩, ⟨sec⟩, ⟨msec⟩)None
DATETIMEOFFSETFROMPARTSRewrittenmake_timestamp(⟨y⟩, ⟨m⟩, ⟨d⟩, ⟨h⟩, ⟨min⟩, ⟨sec⟩)None
DAYSame nameDAYNone
DAY(DATE argument)Rewrittendate_part('day',⟨n⟩)None
EOMONTH(⟨date⟩) with a date/time typed argumentRewritten(date_trunc('MONTH',⟨date⟩) + INTERVAL '1 MONTH - 1 day')::DATENone
EOMONTH(⟨date⟩) with any other argument typeRewritten(date_trunc('MONTH',⟨date⟩::TIMESTAMP) + INTERVAL '1 MONTH - 1 day')::DATENone
EOMONTH(⟨date⟩, ⟨months⟩) with a date/time typed argumentRewritten(date_trunc('MONTH',⟨date⟩) + (1+⟨number⟩::numeric || ' Month - 1 day')::interval)::DATENone
EOMONTH(⟨date⟩, ⟨months⟩) with any other argument typeRewritten(date_trunc('MONTH',⟨date⟩::TIMESTAMP) + (1+⟨number⟩::numeric || ' Month - 1 day')::interval)::DATENone
GETDATERewrittenclock_timestamp()None
GETUTCDATERewrittentimezone('UTC', CURRENT_TIMESTAMP(6))None
ISDATENot convertedNot applicable7811: PostgreSQL doesn't support the ISDATE function. DMS SC skips this unsupported function in the converted code
MONTHSame nameMONTHNone
MONTH(DATE argument)Rewrittendate_part('month',⟨n⟩)None
SMALLDATETIMEFROMPARTSRewrittenmake_timestamp(⟨y⟩, ⟨m⟩, ⟨d⟩, ⟨h⟩, ⟨min⟩, 0)None
SP_HELPDBNot convertedNot applicable7904: DMS SC can't convert the SP_HELPDB system object
SP_OASTOPNot convertedNot applicable7904: DMS SC can't convert the SP_OASTOP system object
SWITCHOFFSETNot convertedNot applicable7811: PostgreSQL doesn't support the SWITCHOFFSET function. DMS SC skips this unsupported function in the converted code
SYSCOLUMNSNot convertedNot applicable7904: DMS SC can't convert the SYSCOLUMNS system object
SYSDATETIMERewrittenclock_timestamp()None
SYSDATETIMEOFFSETRewrittencurrent_timestamp(6)None
SYSFILESNot convertedNot applicable7904: DMS SC can't convert the SYSFILES system object
SYSUTCDATETIMERewrittentimezone('UTC', LOCALTIMESTAMP(6))None
TIMEFROMPARTSExtension packaws_sqlserver_ext.timefromparts(⟨h⟩, ⟨min⟩, ⟨sec⟩, ⟨frc⟩, ⟨prcn⟩)None
TODATETIMEOFFSETNot convertedNot applicable7811: PostgreSQL doesn't support the TODATETIMEOFFSET function. DMS SC skips this unsupported function in the converted code
YEARSame nameYEARNone
YEAR(DATE argument)Rewrittendate_part('year',⟨n⟩)None

Database Mail messenger objects

The following table lists each source object in the Database Mail messenger objects category and shows how DMS Schema Conversion converts it.

SourceConversionTargetAction item
MSDB.DBO.SP_SEND_DBMAILExtension packaws_sqlserver_ext.SP_SEND_DBMAILNone
MSDB.DBO.SYSMAIL_ALLITEMSExtension packaws_sqlserver_ext.SYSMAIL_ALLITEMSNone
MSDB.DBO.SYSMAIL_DELETE_LOG_SPNot convertedNot applicable7900: PostgreSQL doesn't support functionality similar to SQL Server Database Mail
MSDB.DBO.SYSMAIL_DELETE_MAILITEMS_SPExtension packaws_sqlserver_ext.SYSMAIL_DELETE_MAILITEMS_SPNone
MSDB.DBO.SYSMAIL_EVENT_LOGNot convertedNot applicable7900: PostgreSQL doesn't support functionality similar to SQL Server Database Mail
MSDB.DBO.SYSMAIL_FAILEDITEMSExtension packaws_sqlserver_ext.SYSMAIL_FAILEDITEMSNone
MSDB.DBO.SYSMAIL_HELP_QUEUE_SPNot convertedNot applicable7900: PostgreSQL doesn't support functionality similar to SQL Server Database Mail
MSDB.DBO.SYSMAIL_LOGMAILEVENT_SPNot convertedNot applicable7900: PostgreSQL doesn't support functionality similar to SQL Server Database Mail
MSDB.DBO.SYSMAIL_MAILATTACHMENTSExtension packaws_sqlserver_ext.SYSMAIL_MAILATTACHMENTSNone
MSDB.DBO.SYSMAIL_SENTITEMSExtension packaws_sqlserver_ext.SYSMAIL_SENTITEMSNone
MSDB.DBO.SYSMAIL_UNSENTITEMSExtension packaws_sqlserver_ext.SYSMAIL_UNSENTITEMSNone

JSON functions

In the JSON functions category, DMS Schema Conversion does not automatically convert any source objects. You must convert these objects manually. The following table lists these source objects.

SourceConversionTargetAction item
ISJSONNot convertedNot applicable7939: DMS SC can't convert the ISJSON JSON system function
JSON_MODIFYNot convertedNot applicable7939: DMS SC can't convert the JSON_MODIFY JSON system function
JSON_QUERYNot convertedNot applicable7939: DMS SC can't convert the JSON_QUERY JSON system function
JSON_VALUENot convertedNot applicable7939: DMS SC can't convert the JSON_VALUE JSON system function

Mathematical

The following table lists each source object in the Mathematical category and shows how DMS Schema Conversion converts it.

SourceConversionTargetAction item
ABSSame nameABSNone
ACOSSame nameACOSNone
ASINSame nameASINNone
ATANSame nameATANNone
ATN2RenamedATAN2None
CEILINGSame nameCEILINGNone
COSSame nameCOSNone
COTSame nameCOTNone
DEGREESSame nameDEGREESNone
EXPSame nameEXPNone
FLOORSame nameFLOORNone
LOG(⟨expr⟩)RenamedLNNone
LOG(⟨expr⟩, ⟨base⟩)RewrittenLOG(⟨base⟩, ⟨expr⟩)None
LOG10RewrittenLOG(10, ⟨expr⟩)None
PISame namePINone
POWERSame namePOWERNone
RADIANSSame nameRADIANSNone
RAND()RenamedRANDOMNone
RAND(⟨seed⟩)Rewritten(SELECT random() FROM (SELECT setseed((⟨expr⟩) / 2147483649.)))None
ROUND(⟨expr⟩, ⟨length⟩)Same nameROUNDNone
ROUND(⟨expr⟩, ⟨length⟩, ⟨function⟩)Extension packaws_sqlserver_ext.ROUND3None
SIGNSame nameSIGNNone
SINSame nameSINNone
SQRTSame nameSQRTNone
SQUARERewrittenPOWER(⟨exp⟩, 2)None
TANSame nameTANNone

Metadata functions

The following table lists each source object in the Metadata functions category and shows how DMS Schema Conversion converts it.

SourceConversionTargetAction item
@@PROCIDNot convertedNot applicable7811: PostgreSQL doesn't support the @@PROCID function. DMS SC skips this unsupported function in the converted code
APP_NAMENot convertedNot applicable7811: PostgreSQL doesn't support the APP_NAME function. DMS SC skips this unsupported function in the converted code
DB_NAMERenamedcurrent_databaseNone
SERVERPROPERTYNot convertedNot applicable7811: PostgreSQL doesn't support the SERVERPROPERTY function. DMS SC skips this unsupported function in the converted code

Other

The following table lists each source object in the Other category and shows how DMS Schema Conversion converts it.

SourceConversionTargetAction item
APPROX_COUNT_DISTINCTNot convertedNot applicable7811: PostgreSQL doesn't support the APPROX_COUNT_DISTINCT function. DMS SC skips this unsupported function in the converted code
APPROX_PERCENTILE_CONTNot convertedNot applicable7811: PostgreSQL doesn't support the APPROX_PERCENTILE_CONT function. DMS SC skips this unsupported function in the converted code
APPROX_PERCENTILE_DISCNot convertedNot applicable7811: PostgreSQL doesn't support the APPROX_PERCENTILE_DISC function. DMS SC skips this unsupported function in the converted code
ASSEMBLYPROPERTYNot convertedNot applicable7811: PostgreSQL doesn't support the ASSEMBLYPROPERTY function. DMS SC skips this unsupported function in the converted code
ASYMKEYPROPERTYNot convertedNot applicable7811: PostgreSQL doesn't support the ASYMKEYPROPERTY function. DMS SC skips this unsupported function in the converted code
ASYMKEY_IDNot convertedNot applicable7811: PostgreSQL doesn't support the ASYMKEY_ID function. DMS SC skips this unsupported function in the converted code
BINARY_CHECKSUMNot convertedNot applicable7811: PostgreSQL doesn't support the BINARY_CHECKSUM function. DMS SC skips this unsupported function in the converted code
BIT_COUNTNot convertedNot applicable7811: PostgreSQL doesn't support the BIT_COUNT function. DMS SC skips this unsupported function in the converted code
CERTENCODEDNot convertedNot applicable7811: PostgreSQL doesn't support the CERTENCODED function. DMS SC skips this unsupported function in the converted code
CERTPRIVATEKEYNot convertedNot applicable7811: PostgreSQL doesn't support the CERTPRIVATEKEY function. DMS SC skips this unsupported function in the converted code
CERTPROPERTYNot convertedNot applicable7811: PostgreSQL doesn't support the CERTPROPERTY function. DMS SC skips this unsupported function in the converted code
CERT_IDNot convertedNot applicable7811: PostgreSQL doesn't support the CERT_ID function. DMS SC skips this unsupported function in the converted code
CHECKSUMRewritten('x'||SUBSTR(MD5(⟨expr⟩),1,8))::BIT(32)::INTEGERNone
CHOOSENot convertedNot applicable7811: PostgreSQL doesn't support the CHOOSE function. DMS SC skips this unsupported function in the converted code
COALESCESame nameCOALESCENone
COLLATIONPROPERTYNot convertedNot applicable7811: PostgreSQL doesn't support the COLLATIONPROPERTY function. DMS SC skips this unsupported function in the converted code
COLUMNPROPERTYNot convertedNot applicable7811: PostgreSQL doesn't support the COLUMNPROPERTY function. DMS SC skips this unsupported function in the converted code
COLUMNS_UPDATEDNot convertedNot applicable7909: DMS SC can't convert UPDATE(column) OR COLUMNS_UPDATED statements
COL_LENGTHNot convertedNot applicable7811: PostgreSQL doesn't support the COL_LENGTH function. DMS SC skips this unsupported function in the converted code
COL_NAMENot convertedNot applicable7811: PostgreSQL doesn't support the COL_NAME function. DMS SC skips this unsupported function in the converted code
COMPRESSNot convertedNot applicable7811: PostgreSQL doesn't support the COMPRESS function. DMS SC skips this unsupported function in the converted code
CONNECTIONPROPERTYNot convertedNot applicable7811: PostgreSQL doesn't support the CONNECTIONPROPERTY function. DMS SC skips this unsupported function in the converted code
CURRENT_REQUEST_IDNot convertedNot applicable7811: PostgreSQL doesn't support the CURRENT_REQUEST_ID function. DMS SC skips this unsupported function in the converted code
CURRENT_TIMEZONENot convertedNot applicable7811: PostgreSQL doesn't support the CURRENT_TIMEZONE function. DMS SC skips this unsupported function in the converted code
CURRENT_TIMEZONE_IDNot convertedNot applicable7811: PostgreSQL doesn't support the CURRENT_TIMEZONE_ID function. DMS SC skips this unsupported function in the converted code
CURRENT_TRANSACTION_IDNot convertedNot applicable7811: PostgreSQL doesn't support the CURRENT_TRANSACTION_ID function. DMS SC skips this unsupported function in the converted code
CURRENT_USERNot convertedNot applicable7811: PostgreSQL doesn't support the CURRENT_USER function. DMS SC skips this unsupported function in the converted code
CURSOR_STATUSNot convertedNot applicable7811: PostgreSQL doesn't support the CURSOR_STATUS function. DMS SC skips this unsupported function in the converted code
DATABASEPROPERTYEXNot convertedNot applicable7811: PostgreSQL doesn't support the DATABASEPROPERTYEX function. DMS SC skips this unsupported function in the converted code
DATABASE_PRINCIPAL_IDNot convertedNot applicable7811: PostgreSQL doesn't support the DATABASE_PRINCIPAL_ID function. DMS SC skips this unsupported function in the converted code
DATEDIFF_BIGNot convertedNot applicable7811: PostgreSQL doesn't support the DATEDIFF_BIG function. DMS SC skips this unsupported function in the converted code
DATETRUNCNot convertedNot applicable7811: PostgreSQL doesn't support the DATETRUNC function. DMS SC skips this unsupported function in the converted code
DATE_BUCKETNot convertedNot applicable7811: PostgreSQL doesn't support the DATE_BUCKET function. DMS SC skips this unsupported function in the converted code
DB_IDNot convertedNot applicable7811: PostgreSQL doesn't support the DB_ID function. DMS SC skips this unsupported function in the converted code
DECOMPRESSNot convertedNot applicable7811: PostgreSQL doesn't support the DECOMPRESS function. DMS SC skips this unsupported function in the converted code
DECRYPTBYASYMKEYNot convertedNot applicable7811: PostgreSQL doesn't support the DECRYPTBYASYMKEY function. DMS SC skips this unsupported function in the converted code
DECRYPTBYCERTNot convertedNot applicable7811: PostgreSQL doesn't support the DECRYPTBYCERT function. DMS SC skips this unsupported function in the converted code
DECRYPTBYKEYNot convertedNot applicable7811: PostgreSQL doesn't support the DECRYPTBYKEY function. DMS SC skips this unsupported function in the converted code
DECRYPTBYKEYAUTOASYMKEYNot convertedNot applicable7811: PostgreSQL doesn't support the DECRYPTBYKEYAUTOASYMKEY function. DMS SC skips this unsupported function in the converted code
DECRYPTBYKEYAUTOCERTNot convertedNot applicable7811: PostgreSQL doesn't support the DECRYPTBYKEYAUTOCERT function. DMS SC skips this unsupported function in the converted code
DECRYPTBYPASSPHRASENot convertedNot applicable7811: PostgreSQL doesn't support the DECRYPTBYPASSPHRASE function. DMS SC skips this unsupported function in the converted code
DENSE_RANKSame nameDENSE_RANKNone
ENCRYPTBYASYMKEYNot convertedNot applicable7811: PostgreSQL doesn't support the ENCRYPTBYASYMKEY function. DMS SC skips this unsupported function in the converted code
ENCRYPTBYCERTNot convertedNot applicable7811: PostgreSQL doesn't support the ENCRYPTBYCERT function. DMS SC skips this unsupported function in the converted code
ENCRYPTBYKEYNot convertedNot applicable7811: PostgreSQL doesn't support the ENCRYPTBYKEY function. DMS SC skips this unsupported function in the converted code
ENCRYPTBYPASSPHRASENot convertedNot applicable7811: PostgreSQL doesn't support the ENCRYPTBYPASSPHRASE function. DMS SC skips this unsupported function in the converted code
ERROR_LINERewrittenerror_catch$ERROR_LINENone
ERROR_MESSAGERewrittenerror_catch$ERROR_MESSAGENone
ERROR_NUMBERRewrittenerror_catch$ERROR_NUMBERNone
ERROR_PROCEDURERewrittenerror_catch$ERROR_PROCEDURENone
ERROR_SEVERITYRewrittenerror_catch$ERROR_SEVERITYNone
ERROR_STATERewrittenerror_catch$ERROR_STATENone
EVENTDATANot convertedNot applicable7811: PostgreSQL doesn't support the EVENTDATA function. DMS SC skips this unsupported function in the converted code
FILEGROUPPROPERTYNot convertedNot applicable7811: PostgreSQL doesn't support the FILEGROUPPROPERTY function. DMS SC skips this unsupported function in the converted code
FILEGROUP_IDNot convertedNot applicable7811: PostgreSQL doesn't support the FILEGROUP_ID function. DMS SC skips this unsupported function in the converted code
FILEGROUP_NAMENot convertedNot applicable7811: PostgreSQL doesn't support the FILEGROUP_NAME function. DMS SC skips this unsupported function in the converted code
FILEPROPERTYNot convertedNot applicable7811: PostgreSQL doesn't support the FILEPROPERTY function. DMS SC skips this unsupported function in the converted code
FILEPROPERTYEXNot convertedNot applicable7811: PostgreSQL doesn't support the FILEPROPERTYEX function. DMS SC skips this unsupported function in the converted code
FILE_IDNot convertedNot applicable7811: PostgreSQL doesn't support the FILE_ID function. DMS SC skips this unsupported function in the converted code
FILE_IDEXNot convertedNot applicable7811: PostgreSQL doesn't support the FILE_IDEX function. DMS SC skips this unsupported function in the converted code
FILE_NAMENot convertedNot applicable7811: PostgreSQL doesn't support the FILE_NAME function. DMS SC skips this unsupported function in the converted code
FORMATMESSAGENot convertedNot applicable7811: PostgreSQL doesn't support the FORMATMESSAGE function. DMS SC skips this unsupported function in the converted code
FULLTEXTCATALOGPROPERTYNot convertedNot applicable7811: PostgreSQL doesn't support the FULLTEXTCATALOGPROPERTY function. DMS SC skips this unsupported function in the converted code
FULLTEXTSERVICEPROPERTYNot convertedNot applicable7811: PostgreSQL doesn't support the FULLTEXTSERVICEPROPERTY function. DMS SC skips this unsupported function in the converted code
GETANSINULLNot convertedNot applicable7811: PostgreSQL doesn't support the GETANSINULL function. DMS SC skips this unsupported function in the converted code
GET_BITNot convertedNot applicable7811: PostgreSQL doesn't support the GET_BIT function. DMS SC skips this unsupported function in the converted code
HAS_DBACCESSNot convertedNot applicable7811: PostgreSQL doesn't support the HAS_DBACCESS function. DMS SC skips this unsupported function in the converted code
HAS_PERMS_BY_NAMENot convertedNot applicable7811: PostgreSQL doesn't support the HAS_PERMS_BY_NAME function. DMS SC skips this unsupported function in the converted code
HOST_IDNot convertedNot applicable7811: PostgreSQL doesn't support the HOST_ID function. DMS SC skips this unsupported function in the converted code
HOST_NAMENot convertedNot applicable7811: PostgreSQL doesn't support the HOST_NAME function. DMS SC skips this unsupported function in the converted code
IDENT_CURRENTNot convertedNot applicable7811: PostgreSQL doesn't support the IDENT_CURRENT function. DMS SC skips this unsupported function in the converted code
IDENT_INCRNot convertedNot applicable7811: PostgreSQL doesn't support the IDENT_INCR function. DMS SC skips this unsupported function in the converted code
IDENT_SEEDNot convertedNot applicable7811: PostgreSQL doesn't support the IDENT_SEED function. DMS SC skips this unsupported function in the converted code
INDEXKEY_PROPERTYNot convertedNot applicable7811: PostgreSQL doesn't support the INDEXKEY_PROPERTY function. DMS SC skips this unsupported function in the converted code
INDEXPROPERTYNot convertedNot applicable7811: PostgreSQL doesn't support the INDEXPROPERTY function. DMS SC skips this unsupported function in the converted code
INDEX_COLNot convertedNot applicable7811: PostgreSQL doesn't support the INDEX_COL function. DMS SC skips this unsupported function in the converted code
ISNULLRenamedCOALESCENone
ISNUMERIC(…) with any other number of argumentsNot convertedNot applicable7811: PostgreSQL doesn't support the ISNUMERIC(…) function. DMS SC skips this unsupported function in the converted code
ISNUMERIC(⟨expr⟩)Extension packaws_sqlserver_ext.isnumeric(⟨expr⟩)None
IS_MEMBERNot convertedNot applicable7811: PostgreSQL doesn't support the IS_MEMBER function. DMS SC skips this unsupported function in the converted code
IS_OBJECTSIGNEDNot convertedNot applicable7811: PostgreSQL doesn't support the IS_OBJECTSIGNED function. DMS SC skips this unsupported function in the converted code
IS_ROLEMEMBERNot convertedNot applicable7811: PostgreSQL doesn't support the IS_ROLEMEMBER function. DMS SC skips this unsupported function in the converted code
IS_SRVROLEMEMBERNot convertedNot applicable7811: PostgreSQL doesn't support the IS_SRVROLEMEMBER function. DMS SC skips this unsupported function in the converted code
JSON_OBJECTNot convertedNot applicable7811: PostgreSQL doesn't support the JSON_OBJECT function. DMS SC skips this unsupported function in the converted code
JSON_PATH_EXISTSNot convertedNot applicable7811: PostgreSQL doesn't support the JSON_PATH_EXISTS function. DMS SC skips this unsupported function in the converted code
KEY_GUIDNot convertedNot applicable7811: PostgreSQL doesn't support the KEY_GUID function. DMS SC skips this unsupported function in the converted code
KEY_IDNot convertedNot applicable7811: PostgreSQL doesn't support the KEY_ID function. DMS SC skips this unsupported function in the converted code
KEY_NAMENot convertedNot applicable7811: PostgreSQL doesn't support the KEY_NAME function. DMS SC skips this unsupported function in the converted code
LEFT_SHIFTNot convertedNot applicable7811: PostgreSQL doesn't support the LEFT_SHIFT function. DMS SC skips this unsupported function in the converted code
LOGINPROPERTYNot convertedNot applicable7811: PostgreSQL doesn't support the LOGINPROPERTY function. DMS SC skips this unsupported function in the converted code
MIN_ACTIVE_ROWVERSIONNot convertedNot applicable7811: PostgreSQL doesn't support the MIN_ACTIVE_ROWVERSION function. DMS SC skips this unsupported function in the converted code
NEWIDRenameduuid_generate_v47831: Make sure that you install the uuid-ossp extension to use the newid() function
NEWSEQUENTIALIDNot convertedNot applicable7811: PostgreSQL doesn't support the NEWSEQUENTIALID function. DMS SC skips this unsupported function in the converted code
NTILESame nameNTILENone
NULLIFSame nameNULLIFNone
OBJECTPROPERTYNot convertedNot applicable7811: PostgreSQL doesn't support the OBJECTPROPERTY function. DMS SC skips this unsupported function in the converted code
OBJECTPROPERTYEXNot convertedNot applicable7811: PostgreSQL doesn't support the OBJECTPROPERTYEX function. DMS SC skips this unsupported function in the converted code
OBJECT_DEFINITIONNot convertedNot applicable7811: PostgreSQL doesn't support the OBJECT_DEFINITION function. DMS SC skips this unsupported function in the converted code
OBJECT_IDExtension packaws_sqlserver_ext.object_idNone
OBJECT_NAMENot convertedNot applicable7811: PostgreSQL doesn't support the OBJECT_NAME function. DMS SC skips this unsupported function in the converted code
OBJECT_SCHEMA_NAMENot convertedNot applicable7811: PostgreSQL doesn't support the OBJECT_SCHEMA_NAME function. DMS SC skips this unsupported function in the converted code
ORIGINAL_DB_NAMENot convertedNot applicable7811: PostgreSQL doesn't support the ORIGINAL_DB_NAME function. DMS SC skips this unsupported function in the converted code
ORIGINAL_LOGINNot convertedNot applicable7811: PostgreSQL doesn't support the ORIGINAL_LOGIN function. DMS SC skips this unsupported function in the converted code
PARSENAMENot convertedNot applicable7811: PostgreSQL doesn't support the PARSENAME function. DMS SC skips this unsupported function in the converted code
PERCENTILE_CONTNot convertedNot applicable7811: PostgreSQL doesn't support the PERCENTILE_CONT function. DMS SC skips this unsupported function in the converted code
PERCENTILE_DISCNot convertedNot applicable7811: PostgreSQL doesn't support the PERCENTILE_DISC function. DMS SC skips this unsupported function in the converted code
PERMISSIONSNot convertedNot applicable7811: PostgreSQL doesn't support the PERMISSIONS function. DMS SC skips this unsupported function in the converted code
PUBLISHINGSERVERNAMENot convertedNot applicable7811: PostgreSQL doesn't support the PUBLISHINGSERVERNAME function. DMS SC skips this unsupported function in the converted code
PWDCOMPARENot convertedNot applicable7811: PostgreSQL doesn't support the PWDCOMPARE function. DMS SC skips this unsupported function in the converted code
PWDENCRYPTNot convertedNot applicable7811: PostgreSQL doesn't support the PWDENCRYPT function. DMS SC skips this unsupported function in the converted code
RANKSame nameRANKNone
RIGHT_SHIFTNot convertedNot applicable7811: PostgreSQL doesn't support the RIGHT_SHIFT function. DMS SC skips this unsupported function in the converted code
ROWCOUNT_BIGNot convertedNot applicable7811: PostgreSQL doesn't support the ROWCOUNT_BIG function. DMS SC skips this unsupported function in the converted code
ROW_NUMBERSame nameROW_NUMBERNone
SCHEMA_IDNot convertedNot applicable7811: PostgreSQL doesn't support the SCHEMA_ID function. DMS SC skips this unsupported function in the converted code
SCHEMA_NAMENot convertedNot applicable7811: PostgreSQL doesn't support the SCHEMA_NAME function. DMS SC skips this unsupported function in the converted code
SESSIONPROPERTYNot convertedNot applicable7811: PostgreSQL doesn't support the SESSIONPROPERTY function. DMS SC skips this unsupported function in the converted code
SESSION_CONTEXTNot convertedNot applicable7811: PostgreSQL doesn't support the SESSION_CONTEXT function. DMS SC skips this unsupported function in the converted code
SESSION_USERNot convertedNot applicable7811: PostgreSQL doesn't support the SESSION_USER function. DMS SC skips this unsupported function in the converted code
SET_BITNot convertedNot applicable7811: PostgreSQL doesn't support the SET_BIT function. DMS SC skips this unsupported function in the converted code
SIGNBYASYMKEYNot convertedNot applicable7811: PostgreSQL doesn't support the SIGNBYASYMKEY function. DMS SC skips this unsupported function in the converted code
SIGNBYCERTNot convertedNot applicable7811: PostgreSQL doesn't support the SIGNBYCERT function. DMS SC skips this unsupported function in the converted code
SP_SEQUENCE_GET_RANGEExtension packaws_sqlserver_ext.sp_sequence_get_range(⟨seq_name⟩, ⟨seq_range⟩)None
SQL_VARIANT_PROPERTYNot convertedNot applicable7811: PostgreSQL doesn't support the SQL_VARIANT_PROPERTY function. DMS SC skips this unsupported function in the converted code
STATS_DATENot convertedNot applicable7811: PostgreSQL doesn't support the STATS_DATE function. DMS SC skips this unsupported function in the converted code
STRING_ESCAPENot convertedNot applicable7811: PostgreSQL doesn't support the STRING_ESCAPE function. DMS SC skips this unsupported function in the converted code
SUSER_IDNot convertedNot applicable7811: PostgreSQL doesn't support the SUSER_ID function. DMS SC skips this unsupported function in the converted code
SUSER_NAMENot convertedNot applicable7811: PostgreSQL doesn't support the SUSER_NAME function. DMS SC skips this unsupported function in the converted code
SUSER_SIDNot convertedNot applicable7811: PostgreSQL doesn't support the SUSER_SID function. DMS SC skips this unsupported function in the converted code
SUSER_SNAMERewrittenCURRENT_USERNone
SUSER_SNAME(…) with 1 argumentRewrittenNULLNone
SYMKEYPROPERTYNot convertedNot applicable7811: PostgreSQL doesn't support the SYMKEYPROPERTY function. DMS SC skips this unsupported function in the converted code
SYSFOREIGNKEYSExtension packaws_sqlserver_ext.SYS_SYSFOREIGNKEYSNone
SYSINDEXESExtension packaws_sqlserver_ext.SYS_SYSINDEXESNone
SYSOBJECTSExtension packaws_sqlserver_ext.SYS_SYSOBJECTSNone
SYSPROCESSESExtension packaws_sqlserver_ext.SYS_SYSPROCESSESNone
SYSTEM_USERNot convertedNot applicable7811: PostgreSQL doesn't support the SYSTEM_USER function. DMS SC skips this unsupported function in the converted code
TERTIARY_WEIGHTSNot convertedNot applicable7811: PostgreSQL doesn't support the TERTIARY_WEIGHTS function. DMS SC skips this unsupported function in the converted code
TRIGGER_NESTLEVELNot convertedNot applicable7811: PostgreSQL doesn't support the TRIGGER_NESTLEVEL function. DMS SC skips this unsupported function in the converted code
TYPEPROPERTYNot convertedNot applicable7811: PostgreSQL doesn't support the TYPEPROPERTY function. DMS SC skips this unsupported function in the converted code
TYPE_IDNot convertedNot applicable7811: PostgreSQL doesn't support the TYPE_ID function. DMS SC skips this unsupported function in the converted code
TYPE_NAMENot convertedNot applicable7811: PostgreSQL doesn't support the TYPE_NAME function. DMS SC skips this unsupported function in the converted code
USER_IDNot convertedNot applicable7811: PostgreSQL doesn't support the USER_ID function. DMS SC skips this unsupported function in the converted code
USER_NAMENot convertedNot applicable7811: PostgreSQL doesn't support the USER_NAME function. DMS SC skips this unsupported function in the converted code
VERIFYSIGNEDBYASYMKEYNot convertedNot applicable7811: PostgreSQL doesn't support the VERIFYSIGNEDBYASYMKEY function. DMS SC skips this unsupported function in the converted code
VERIFYSIGNEDBYCERTNot convertedNot applicable7811: PostgreSQL doesn't support the VERIFYSIGNEDBYCERT function. DMS SC skips this unsupported function in the converted code
XACT_STATENot convertedNot applicable7811: PostgreSQL doesn't support the XACT_STATE function. DMS SC skips this unsupported function in the converted code

SQL Server Agent

The following table lists each source object in the SQL Server Agent category and shows how DMS Schema Conversion converts it.

SourceConversionTargetAction item
MSDB.DBO.SP_ADD_ALERTNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_ADD_CATEGORYNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_ADD_JOBExtension packaws_sqlserver_ext.SP_ADD_JOBNone
MSDB.DBO.SP_ADD_JOBSCHEDULEExtension packaws_sqlserver_ext.SP_ADD_JOBSCHEDULENone
MSDB.DBO.SP_ADD_JOBSERVERNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_ADD_JOBSTEPExtension packaws_sqlserver_ext.SP_ADD_JOBSTEPNone
MSDB.DBO.SP_ADD_NOTIFICATIONNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_ADD_OPERATORNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_ADD_PROXYNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_ADD_SCHEDULEExtension packaws_sqlserver_ext.SP_ADD_SCHEDULENone
MSDB.DBO.SP_ADD_TARGETSERVERGROUPNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_ADD_TARGETSVRGRP_MEMBERNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_APPLY_JOB_TO_TARGETSNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_ATTACH_SCHEDULEExtension packaws_sqlserver_ext.SP_ATTACH_SCHEDULENone
MSDB.DBO.SP_CYCLE_AGENT_ERRORLOGNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_CYCLE_ERRORLOGNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_DELETE_ALERTNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_DELETE_CATEGORYNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_DELETE_JOBExtension packaws_sqlserver_ext.SP_DELETE_JOBNone
MSDB.DBO.SP_DELETE_JOBSCHEDULEExtension packaws_sqlserver_ext.SP_DELETE_JOBSCHEDULENone
MSDB.DBO.SP_DELETE_JOBSERVERNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_DELETE_JOBSTEPExtension packaws_sqlserver_ext.SP_DELETE_JOBSTEPNone
MSDB.DBO.SP_DELETE_JOBSTEPLOGNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_DELETE_NOTIFICATIONNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_DELETE_OPERATORNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_DELETE_PROXYNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_DELETE_SCHEDULEExtension packaws_sqlserver_ext.SP_DELETE_SCHEDULENone
MSDB.DBO.SP_DELETE_TARGETSERVERNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_DELETE_TARGETSERVERGROUPNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_DELETE_TARGETSVRGRP_MEMBERNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_DETACH_SCHEDULEExtension packaws_sqlserver_ext.SP_DETACH_SCHEDULENone
MSDB.DBO.SP_ENUM_LOGIN_FOR_PROXYNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_ENUM_PROXY_FOR_SUBSYSTEMNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_ENUM_SQLAGENT_SUBSYSTEMSNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_GRANT_LOGIN_TO_PROXYNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_GRANT_PROXY_TO_SUBSYSTEMNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_HELP_ALERTNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_HELP_CATEGORYNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_HELP_DOWNLOADLISTNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_HELP_JOBNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_HELP_JOBACTIVITYNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_HELP_JOBCOUNTNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_HELP_JOBHISTORYNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_HELP_JOBSCHEDULENot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_HELP_JOBSERVERNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_HELP_JOBSTEPNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_HELP_JOBSTEPLOGNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_HELP_JOBS_IN_SCHEDULENot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_HELP_NOTIFICATIONNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_HELP_OPERATORNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_HELP_PROXYNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_HELP_SCHEDULENot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_HELP_TARGETSERVERNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_HELP_TARGETSERVERGROUPNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_MANAGE_JOBS_BY_LOGINNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_MSX_DEFECTNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_MSX_ENLISTNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_MSX_GET_ACCOUNTNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_MSX_SET_ACCOUNTNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_NOTIFY_OPERATORNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_POST_MSX_OPERATIONNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_PURGE_JOBHISTORYNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_REMOVE_JOB_FROM_TARGETSSNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_RESYNC_TARGETSERVERNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_REVOKE_LOGIN_FROM_PROXYNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_REVOKE_PROXY_FROM_SUBSYSTEMNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_START_JOBNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_STOP_JOBNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_UPDATE_ALERTNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_UPDATE_CATEGORYNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_UPDATE_JOBExtension packaws_sqlserver_ext.SP_UPDATE_JOBNone
MSDB.DBO.SP_UPDATE_JOBSCHEDULEExtension packaws_sqlserver_ext.SP_UPDATE_JOBSCHEDULENone
MSDB.DBO.SP_UPDATE_JOBSTEPExtension packaws_sqlserver_ext.SP_UPDATE_JOBSTEPNone
MSDB.DBO.SP_UPDATE_NOTIFICATIONNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_UPDATE_OPERATORNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_UPDATE_PROXYNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SP_UPDATE_SCHEDULEExtension packaws_sqlserver_ext.SP_UPDATE_SCHEDULENone
MSDB.DBO.SP_UPDATE_TARGETSERVERGROUPNot convertedNot applicable7902: PostgreSQL doesn't support functionality similar to SQL Server Agent
MSDB.DBO.SYSJOBHISTORYExtension packaws_sqlserver_ext.SYSJOBHISTORYNone
MSDB.DBO.SYSJOBSExtension packaws_sqlserver_ext.SYSJOBSNone
MSDB.DBO.SYSJOBSCHEDULESExtension packaws_sqlserver_ext.SYSJOBSCHEDULESNone
MSDB.DBO.SYSJOBSTEPSExtension packaws_sqlserver_ext.SYSJOBSTEPSNone
MSDB.DBO.SYSSCHEDULESExtension packaws_sqlserver_ext.SYSSCHEDULESNone

String

The following table lists each source object in the String category and shows how DMS Schema Conversion converts it.

SourceConversionTargetAction item
ASCIIRewrittenASCII(case ⟨p1⟩ when '' then null else ⟨p1⟩ end)None
CHARRewrittenCHR(NULLIF((⟨charcode⟩) * ((⟨charcode⟩) BETWEEN 1 AND 255)::INT, 0))None
CHARINDEX(⟨substr⟩, ⟨string⟩)RewrittenSTRPOS(⟨p2⟩, ⟨p1⟩)None
CHARINDEX(⟨substr⟩, ⟨string⟩, ⟨start⟩)Extension packaws_sqlserver_ext.STRPOS3(⟨p1⟩, ⟨p2⟩, ⟨p3⟩)None
CONCATSame nameCONCATNone
DIFFERENCENot convertedNot applicable7811: PostgreSQL doesn't support the DIFFERENCE function. DMS SC skips this unsupported function in the converted code
FORMATNot convertedNot applicable7811: PostgreSQL doesn't support the FORMAT function. DMS SC skips this unsupported function in the converted code
LEFTSame nameLEFTNone
LENRenamedLENGTHNone
LOWERSame nameLOWERNone
LTRIMSame nameLTRIMNone
NCHARNot convertedNot applicable7811: PostgreSQL doesn't support the NCHAR function. DMS SC skips this unsupported function in the converted code
PATINDEXExtension packaws_sqlserver_ext.patindex(⟨p1⟩, ⟨p2⟩)None
QUOTENAMERenamedQUOTE_IDENTNone
QUOTENAME(…) with 2 argumentsNot convertedNot applicable7811: PostgreSQL doesn't support the QUOTENAME(…) function. DMS SC skips this unsupported function in the converted code
REPLACERewrittenregexp_replace(⟨p1⟩,⟨p2⟩,⟨p3⟩,'gi')None
REPLICATERewrittenREPEAT( ⟨p1⟩, case when ⟨p2⟩<0 then null::int else ⟨p2⟩ end)None
REVERSESame nameREVERSENone
RIGHTSame nameRIGHTNone
RTRIMSame nameRTRIMNone
SOUNDEXNot convertedNot applicable7811: PostgreSQL doesn't support the SOUNDEX function. DMS SC skips this unsupported function in the converted code
SPACERewrittenREPEAT( ' ', case when ⟨p1⟩<0 then null else ⟨p1⟩ end)None
STR(⟨expr⟩)Rewrittento_char(⟨arg⟩::double precision,'9999999999')None
STR(⟨expr⟩, ⟨length⟩) with a literal length of 1 to 8000Rewrittento_char(⟨expression⟩::double precision, ⟨mask⟩) — the mask is 9 repeated ⟨length⟩ timesNone
STR(⟨expr⟩, ⟨length⟩) with any other lengthRewrittento_char(⟨expression⟩::double precision, null)None
STR(⟨expr⟩, ⟨length⟩, ⟨decimal⟩)Extension packaws_sqlserver_ext.str(⟨expression⟩::double precision, ⟨length⟩, ⟨decimal⟩)None
STUFFRewrittenOVERLAY(⟨p1⟩ placing ⟨p4⟩ from ⟨p2⟩ for ⟨p3⟩)None
SUBSTRINGRenamedSUBSTRNone
UNICODENot convertedNot applicable7811: PostgreSQL doesn't support the UNICODE function. DMS SC skips this unsupported function in the converted code
UPPERSame nameUPPERNone

Security

In the Security category, DMS Schema Conversion does not automatically convert any source objects. You must convert these objects manually. The following table lists these source objects.

SourceConversionTargetAction item
MSDB.DBO.SYSMAIL_ADD_PRINCIPALPROFILE_SPNot convertedNot applicable7900: PostgreSQL doesn't support functionality similar to SQL Server Database Mail
MSDB.DBO.SYSMAIL_DELETE_PRINCIPALPROFILE_SPNot convertedNot applicable7900: PostgreSQL doesn't support functionality similar to SQL Server Database Mail
MSDB.DBO.SYSMAIL_HELP_PRINCIPALPROFILE_SPNot convertedNot applicable7900: PostgreSQL doesn't support functionality similar to SQL Server Database Mail
MSDB.DBO.SYSMAIL_UPDATE_PRINCIPALPROFILE_SPNot convertedNot applicable7900: PostgreSQL doesn't support functionality similar to SQL Server Database Mail

Service Broker catalog views

In the Service Broker catalog views category, DMS Schema Conversion does not automatically convert any source objects. You must convert these objects manually. The following table lists these source objects.

SourceConversionTargetAction item
SYS.CONVERSATION_ENDPOINTSNot convertedNot applicable7901: PostgreSQL doesn't support functionality similar to SQL Server Service Broker
SYS.CONVERSATION_GROUPSNot convertedNot applicable7901: PostgreSQL doesn't support functionality similar to SQL Server Service Broker
SYS.CONVERSATION_PRIORITIESNot convertedNot applicable7901: PostgreSQL doesn't support functionality similar to SQL Server Service Broker
SYS.MESSAGE_TYPE_XML_SCHEMA_COLLECTION_USAGESNot convertedNot applicable7901: PostgreSQL doesn't support functionality similar to SQL Server Service Broker
SYS.REMOTE_SERVICE_BINDINGSNot convertedNot applicable7901: PostgreSQL doesn't support functionality similar to SQL Server Service Broker
SYS.ROUTESNot convertedNot applicable7901: PostgreSQL doesn't support functionality similar to SQL Server Service Broker
SYS.SERVICESNot convertedNot applicable7901: PostgreSQL doesn't support functionality similar to SQL Server Service Broker
SYS.SERVICE_CONTRACTSNot convertedNot applicable7901: PostgreSQL doesn't support functionality similar to SQL Server Service Broker
SYS.SERVICE_CONTRACT_MESSAGE_USAGESNot convertedNot applicable7901: PostgreSQL doesn't support functionality similar to SQL Server Service Broker
SYS.SERVICE_CONTRACT_USAGESNot convertedNot applicable7901: PostgreSQL doesn't support functionality similar to SQL Server Service Broker
SYS.SERVICE_MESSAGE_TYPESNot convertedNot applicable7901: PostgreSQL doesn't support functionality similar to SQL Server Service Broker
SYS.SERVICE_QUEUESNot convertedNot applicable7901: PostgreSQL doesn't support functionality similar to SQL Server Service Broker
SYS.SERVICE_QUEUE_USAGESNot convertedNot applicable7901: PostgreSQL doesn't support functionality similar to SQL Server Service Broker
SYS.TRANSMISSION_QUEUENot convertedNot applicable7901: PostgreSQL doesn't support functionality similar to SQL Server Service Broker

In the Service Broker related dynamic management views category, DMS Schema Conversion does not automatically convert any source objects. You must convert these objects manually. The following table lists these source objects.

SourceConversionTargetAction item
SYS.DM_BROKER_ACTIVATED_TASKSNot convertedNot applicable7901: PostgreSQL doesn't support functionality similar to SQL Server Service Broker
SYS.DM_BROKER_CONNECTIONSNot convertedNot applicable7901: PostgreSQL doesn't support functionality similar to SQL Server Service Broker
SYS.DM_BROKER_FORWARDED_MESSAGESNot convertedNot applicable7901: PostgreSQL doesn't support functionality similar to SQL Server Service Broker
SYS.DM_BROKER_QUEUE_MONITORSNot convertedNot applicable7901: PostgreSQL doesn't support functionality similar to SQL Server Service Broker

Settings

In the Settings category, DMS Schema Conversion does not automatically convert any source objects. You must convert these objects manually. The following table lists these source objects.

SourceConversionTargetAction item
MSDB.DBO.SYSMAIL_CONFIGURE_SPNot convertedNot applicable7900: PostgreSQL doesn't support functionality similar to SQL Server Database Mail
MSDB.DBO.SYSMAIL_HELP_CONFIGURE_SPNot convertedNot applicable7900: PostgreSQL doesn't support functionality similar to SQL Server Database Mail

Spatial types

The following table lists each source object in the Spatial types category and shows how DMS Schema Conversion converts it.

SourceConversionTargetAction item
GEOGRAPHY.ASBINARYZMRewrittenST_AsBinary(⟨spat⟩)None
GEOGRAPHY.ASGMLRewrittenST_AsGml(⟨spat⟩)::XMLNone
GEOGRAPHY.ASTEXTZMRewrittenST_AsText(⟨spat⟩)None
GEOGRAPHY.BUFFERWITHCURVESRewrittencase when ⟨par1⟩ = 0 then ⟨spat⟩ when ⟨par1⟩ < 1e-11 then ⟨spat⟩ else ST_Buffer(⟨spat⟩, ⟨par1⟩) endNone
GEOGRAPHY.BUFFERWITHTOLERANCENot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.BUFFERWITHTOLERANCE function
GEOGRAPHY.COLLECTIONAGGREGATENot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.COLLECTIONAGGREGATE function
GEOGRAPHY.CONVEXHULLAGGREGATENot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.CONVEXHULLAGGREGATE function
GEOGRAPHY.CURVETOLINEWITHTOLERANCENot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.CURVETOLINEWITHTOLERANCE function
GEOGRAPHY.ENVELOPEAGGREGATENot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.ENVELOPEAGGREGATE function
GEOGRAPHY.ENVELOPEANGLENot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.ENVELOPEANGLE function
GEOGRAPHY.ENVELOPECENTERNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.ENVELOPECENTER function
GEOGRAPHY.FILTERRewritten(case ST_Intersects(⟨spat⟩,⟨par1⟩) when true then 1 when false then 0 else null end)::NUMERIC(1)None
GEOGRAPHY.GEOMFROMGMLNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.GEOMFROMGML function
GEOGRAPHY.HASMNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.HASM function
GEOGRAPHY.HASZNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.HASZ function
GEOGRAPHY.INSTANCEOFNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.INSTANCEOF function
GEOGRAPHY.ISNULLRewritten(case when ⟨spat⟩ is null then null else 0 end)::NUMERIC(1)None
GEOGRAPHY.ISVALIDDETAILEDNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.ISVALIDDETAILED function
GEOGRAPHY.LATRewrittenST_Y(geography::⟨spat⟩)None
GEOGRAPHY.LONGRewrittenST_X(geography::⟨spat⟩)None
GEOGRAPHY.MNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.M function
GEOGRAPHY.MAKEVALIDNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.MAKEVALID function
GEOGRAPHY.MINDBCOMPABILITYLEVELNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.MINDBCOMPABILITYLEVEL function
GEOGRAPHY.MINDBCOMPATIBILITYLEVELNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.MINDBCOMPATIBILITYLEVEL function
GEOGRAPHY.NULLRenamednull::GEOGRAPHYNone
GEOGRAPHY.NUMRINGSNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.NUMRINGS function
GEOGRAPHY.PARSERewrittenST_GeogFromText('SRID='||4326::VARCHAR||';'||⟨p_text⟩)None
GEOGRAPHY.POINTRewrittenST_SetSRID(ST_Point(⟨p1⟩, ⟨p2⟩), ⟨p3⟩)::GEOGRAPHYNone
GEOGRAPHY.REDUCENot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.REDUCE function
GEOGRAPHY.REORIENTOBJECTNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.REORIENTOBJECT function
GEOGRAPHY.RINGNNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.RINGN function
GEOGRAPHY.SHORTESTLINENot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.SHORTESTLINE function
GEOGRAPHY.SHORTESTLINETONot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.SHORTESTLINETO function
GEOGRAPHY.STASBINARYRewrittenST_AsBinary(⟨spat⟩)None
GEOGRAPHY.STASTEXTRewrittenST_AsText(⟨spat⟩)None
GEOGRAPHY.STBUFFERRewrittenST_Buffer(⟨spat⟩, ⟨par1⟩)None
GEOGRAPHY.STCONTAINSNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STCONTAINS function
GEOGRAPHY.STCONVEXHULLNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STCONVEXHULL function
GEOGRAPHY.STCURVENNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STCURVEN function
GEOGRAPHY.STCURVETOLINENot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STCURVETOLINE function
GEOGRAPHY.STDIFFERENCENot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STDIFFERENCE function
GEOGRAPHY.STDIMENSIONRewritten(case ST_IsEmpty(⟨spat⟩) when true then -1 else ST_Dimension(⟨spat⟩) end)::numeric(10)None
GEOGRAPHY.STDISJOINTNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STDISJOINT function
GEOGRAPHY.STDISTANCERewrittenST_Distance(⟨spat⟩, ⟨par1⟩)::DOUBLE PRECISIONNone
GEOGRAPHY.STENDPOINTNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STENDPOINT function
GEOGRAPHY.STEQUALSNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STEQUALS function
GEOGRAPHY.STGEOMCOLLFROMTEXTNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STGEOMCOLLFROMTEXT function
GEOGRAPHY.STGEOMCOLLFROMWKBNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STGEOMCOLLFROMWKB function
GEOGRAPHY.STGEOMETRYNNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STGEOMETRYN function
GEOGRAPHY.STGEOMETRYTYPENot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STGEOMETRYTYPE function
GEOGRAPHY.STGEOMFROMTEXTRewrittenST_GeogFromText('SRID='||⟨p2⟩::VARCHAR||';'||⟨p1⟩)None
GEOGRAPHY.STGEOMFROMWKBNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STGEOMFROMWKB function
GEOGRAPHY.STINTERSECTIONRewrittenST_Intersection(⟨spat⟩, ⟨par1⟩)None
GEOGRAPHY.STINTERSECTSRewritten(case ST_Intersects(⟨spat⟩, ⟨par1⟩) when true then 1 when false then 0 else null end)::NUMERIC(1)None
GEOGRAPHY.STISCLOSEDNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STISCLOSED function
GEOGRAPHY.STISEMPTYNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STISEMPTY function
GEOGRAPHY.STISVALIDNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STISVALID function
GEOGRAPHY.STLENGTHRewrittenST_Length(⟨spat⟩)::DOUBLE PRECISIONNone
GEOGRAPHY.STLINEFROMTEXTNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STLINEFROMTEXT function
GEOGRAPHY.STLINEFROMWKBNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STLINEFROMWKB function
GEOGRAPHY.STMLINEFROMTEXTNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STMLINEFROMTEXT function
GEOGRAPHY.STMLINEFROMWKBNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STMLINEFROMWKB function
GEOGRAPHY.STMPOINTFROMTEXTNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STMPOINTFROMTEXT function
GEOGRAPHY.STMPOINTFROMWKBNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STMPOINTFROMWKB function
GEOGRAPHY.STMPOLYFROMTEXTNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STMPOLYFROMTEXT function
GEOGRAPHY.STMPOLYFROMWKBNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STMPOLYFROMWKB function
GEOGRAPHY.STNUMCURVESNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STNUMCURVES function
GEOGRAPHY.STNUMGEOMETRIESNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STNUMGEOMETRIES function
GEOGRAPHY.STNUMPOINTSNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STNUMPOINTS function
GEOGRAPHY.STOVERLAPSNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STOVERLAPS function
GEOGRAPHY.STPOINTNNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STPOINTN function
GEOGRAPHY.STSRIDNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STSRID function
GEOGRAPHY.STSTARTPOINTNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STSTARTPOINT function
GEOGRAPHY.STSYMDIFFERENCENot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STSYMDIFFERENCE function
GEOGRAPHY.STUNIONNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STUNION function
GEOGRAPHY.STWITHINNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.STWITHIN function
GEOGRAPHY.TOSTRINGRewrittenST_AsText(⟨spat⟩)None
GEOGRAPHY.UNIONAGGREGATENot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.UNIONAGGREGATE function
GEOGRAPHY.ZNot convertedNot applicable7917: PostgreSQL doesn't support the GEOGRAPHY.Z function
GEOMETRY.ASBINARYZMRewrittenST_AsBinary(⟨spat⟩)None
GEOMETRY.ASGMLRewrittenST_AsGml(⟨spat⟩)::XMLNone
GEOMETRY.ASTEXTZMRewrittenST_AsText(⟨spat⟩)None
GEOMETRY.BUFFERWITHCURVESRewrittencase when ⟨par1⟩ = 0 then ⟨spat⟩ when ⟨par1⟩ < 1e-11 then ⟨spat⟩ else ST_Buffer(⟨spat⟩, ⟨par1⟩) endNone
GEOMETRY.BUFFERWITHTOLERANCENot convertedNot applicable7917: PostgreSQL doesn't support the GEOMETRY.BUFFERWITHTOLERANCE function
GEOMETRY.COLLECTIONAGGREGATERewrittenST_Collect(⟨p1⟩)None
GEOMETRY.CONVEXHULLAGGREGATENot convertedNot applicable7917: PostgreSQL doesn't support the GEOMETRY.CONVEXHULLAGGREGATE function
GEOMETRY.CURVETOLINEWITHTOLERANCENot convertedNot applicable7917: PostgreSQL doesn't support the GEOMETRY.CURVETOLINEWITHTOLERANCE function
GEOMETRY.ENVELOPEAGGREGATENot convertedNot applicable7917: PostgreSQL doesn't support the GEOMETRY.ENVELOPEAGGREGATE function
GEOMETRY.FILTERRewritten(case ST_Intersects(⟨spat⟩,⟨par1⟩) when true then 1 when false then 0 else null end)::NUMERIC(1)None
GEOMETRY.GEOMFROMGMLRewrittenST_GeomFromGML(⟨p1⟩, ⟨p2⟩)None
GEOMETRY.HASMRewritten(case geometryAType(⟨spat⟩) when 'POINT' then case when ST_M(⟨spat⟩) is not null then 1 else 0 end else 0 end)::NUMERIC(1)None
GEOMETRY.HASZRewritten(case geometryAType(⟨spat⟩) when 'POINT' then case when ST_Z(⟨spat⟩) is not null then 1 else 0 end else 0 end)::NUMERIC(1)None
GEOMETRY.INSTANCEOFNot convertedNot applicable7917: PostgreSQL doesn't support the GEOMETRY.INSTANCEOF function
GEOMETRY.ISNULLRewritten(case when ⟨spat⟩ is null then null else 0 end)::NUMERIC(1)None
GEOMETRY.ISVALIDDETAILEDRewrittenST_IsValidDetail(⟨spat⟩)::textNone
GEOMETRY.MRewrittenST_M(case when geometryType(⟨spat⟩)!='POINT' then null else ⟨spat⟩ end)::DOUBLE PRECISIONNone
GEOMETRY.MAKEVALIDRewrittenST_MakeValid(⟨spat⟩)None
GEOMETRY.MINDBCOMPABILITYLEVELNot convertedNot applicable7917: PostgreSQL doesn't support the GEOMETRY.MINDBCOMPABILITYLEVEL function
GEOMETRY.MINDBCOMPATIBILITYLEVELNot convertedNot applicable7917: PostgreSQL doesn't support the GEOMETRY.MINDBCOMPATIBILITYLEVEL function
GEOMETRY.NULLRenamednull::GEOMETRYNone
GEOMETRY.PARSERewrittenST_GeomFromText(⟨p_text⟩, 0)None
GEOMETRY.POINTRewrittenST_SetSRID(ST_Point(⟨p1⟩, ⟨p2⟩), ⟨p3⟩)None
GEOMETRY.REDUCERewrittenST_Simplify(⟨spat⟩, ⟨par1⟩)None
GEOMETRY.SHORTESTLINETORewrittenST_ShortestLine(⟨spat⟩, ⟨par1⟩)None
GEOMETRY.STASBINARYRewrittenST_AsBinary(⟨spat⟩)None
GEOMETRY.STASTEXTRewrittenST_AsText(⟨spat⟩)None
GEOMETRY.STBOUNDARYRewrittenST_Boundary(⟨spat⟩)None
GEOMETRY.STBUFFERRewrittenST_Buffer(⟨spat⟩, ⟨par1⟩)None
GEOMETRY.STCENTROIDRewrittenST_Centroid(⟨spat⟩)None
GEOMETRY.STCONTAINSRewritten(case ST_Contains(⟨spat⟩, ⟨par1⟩) when true then 1 when false then 0 else null end)::NUMERIC(1)None
GEOMETRY.STCONVEXHULLRewrittenST_ConvexHull(⟨spat⟩)None
GEOMETRY.STCROSSESRewritten(case ST_Crosses(⟨spat⟩, ⟨par1⟩) when true then 1 when false then 0 else null end)::NUMERIC(1)None
GEOMETRY.STCURVENNot convertedNot applicable7917: PostgreSQL doesn't support the GEOMETRY.STCURVEN function
GEOMETRY.STCURVETOLINERewrittenST_CurveToLine(⟨spat⟩)None
GEOMETRY.STDIFFERENCERewrittenST_Difference(⟨spat⟩, ⟨par1⟩)None
GEOMETRY.STDIMENSIONRewritten(case ST_IsEmpty(⟨spat⟩) when true then -1 else ST_Dimension(⟨spat⟩) end)::numeric(10)None
GEOMETRY.STDISJOINTRewritten(case ST_Disjoint(⟨spat⟩, ⟨par1⟩) when true then 1 when false then 0 else null end)::NUMERIC(1)None
GEOMETRY.STDISTANCERewrittenST_Distance(⟨spat⟩, ⟨par1⟩)::DOUBLE PRECISIONNone
GEOMETRY.STENDPOINTNot convertedNot applicable7917: PostgreSQL doesn't support the GEOMETRY.STENDPOINT function
GEOMETRY.STENVELOPERewrittenST_Envelope(⟨spat⟩)None
GEOMETRY.STEQUALSRewritten(case ST_Equals(⟨spat⟩, ⟨par1⟩) when true then 1 when false then 0 else null end)::NUMERIC(1)None
GEOMETRY.STEXTERIORRINGRewrittenST_Exteriorring(⟨spat⟩)None
GEOMETRY.STGEOMCOLLFROMTEXTRewrittenST_GeomCollFromText(⟨p1⟩, ⟨p2⟩)None
GEOMETRY.STGEOMCOLLFROMWKBRewrittenST_GeomCollFromWKB(⟨p1⟩, ⟨p2⟩)None
GEOMETRY.STGEOMETRYNRewrittenST_geometryN(⟨spat⟩, ⟨par1⟩::numeric(10))None
GEOMETRY.STGEOMETRYTYPERewrittengeometryType(⟨spat⟩)::varchar(4000)None
GEOMETRY.STGEOMFROMTEXTRewrittenST_GeomFromText(⟨p1⟩, ⟨p2⟩)None
GEOMETRY.STGEOMFROMWKBRewrittenST_GeomFromWKB(⟨p1⟩, ⟨p2⟩)None
GEOMETRY.STINTERIORRINGNRewrittenST_InteriorRingN(⟨spat⟩, ⟨par1⟩::numeric(10))None
GEOMETRY.STINTERSECTIONRewrittenST_Intersection(⟨spat⟩, ⟨par1⟩)None
GEOMETRY.STINTERSECTSRewritten(case ST_Intersects(⟨spat⟩, ⟨par1⟩) when true then 1 when false then 0 else null end)::NUMERIC(1)None
GEOMETRY.STISCLOSEDRewritten(case (case when geometryAType(⟨spat⟩) like '%POINT%' then false else ST_IsClosed(⟨spat⟩) end) when false then 0 when true then 1 else null end)::NUMERIC(1)None
GEOMETRY.STISEMPTYRewritten(case ST_IsEmpty(⟨spat⟩) when true then 1 when false then 0 else null end)::numeric(10)None
GEOMETRY.STISRINGRewritten(case ST_IsRing(⟨spat⟩) when true then 1 when false then 0 else null end)::NUMERIC(1)None
GEOMETRY.STISSIMPLERewritten(case ST_IsSimple(⟨spat⟩) when true then 1 when false then 0 else null end)::NUMERIC(1)None
GEOMETRY.STISVALIDRewritten(case ST_Valid(⟨spat⟩) when true then 1 when false then 0 else null end)::NUMERIC(1)None
GEOMETRY.STLENGTHRewrittenST_Length(⟨spat⟩)::DOUBLE PRECISIONNone
GEOMETRY.STLINEFROMTEXTRewrittenST_LineFromText(⟨p1⟩, ⟨p2⟩)None
GEOMETRY.STLINEFROMWKBRewrittenST_LineFromWKB(⟨p1⟩, ⟨p2⟩)None
GEOMETRY.STMLINEFROMTEXTRewrittenST_MLineFromText(⟨p1⟩, ⟨p2⟩)None
GEOMETRY.STMLINEFROMWKBRewrittencase when geometryType(ST_GeomFromWKB(⟨par1⟩, ⟨par2⟩))!='MULTILINESTRING' then null else ST_GeomFromWKB(⟨par1⟩, ⟨par2⟩) endNone
GEOMETRY.STMPOINTFROMTEXTRewrittenST_MPointFromText(⟨p1⟩, ⟨p2⟩)None
GEOMETRY.STMPOINTFROMWKBRewrittenST_MPointFromWKB(⟨p1⟩, ⟨p2⟩)None
GEOMETRY.STMPOLYFROMTEXTRewrittenST_MPolyFromText(⟨p1⟩, ⟨p2⟩)None
GEOMETRY.STMPOLYFROMWKBRewrittenST_MPolyFromWKB(⟨p1⟩, ⟨p2⟩)None
GEOMETRY.STNUMCURVESNot convertedNot applicable7917: PostgreSQL doesn't support the GEOMETRY.STNUMCURVES function
GEOMETRY.STNUMGEOMETRIESRewrittenST_NumGeometries(⟨spat⟩)::numeric(10)None
GEOMETRY.STNUMINTERIORRINGRewrittenST_NumInteriorRings(⟨spat⟩)::numeric(10)None
GEOMETRY.STNUMPOINTSNot convertedNot applicable7917: PostgreSQL doesn't support the GEOMETRY.STNUMPOINTS function
GEOMETRY.STOVERLAPSRewritten(case ST_Overlaps(⟨spat⟩, ⟨par1⟩) when true then 1 when false then 0 else null end)::NUMERIC(1)None
GEOMETRY.STPOINTNNot convertedNot applicable7917: PostgreSQL doesn't support the GEOMETRY.STPOINTN function
GEOMETRY.STPOINTONSURFACERewrittenST_PointOnSurface(⟨spat⟩)None
GEOMETRY.STRELATERewritten(case ST_Relate(⟨spat⟩, ⟨par1⟩, ⟨par2⟩) when true then 1 when false then 0 else null end)::NUMERIC(1)None
GEOMETRY.STSRIDRewrittenST_Srid(⟨spat⟩)::numeric(10)None
GEOMETRY.STSTARTPOINTRewrittenST_Startpoint(⟨spat⟩)None
GEOMETRY.STSYMDIFFERENCERewrittenST_SymDifference(⟨spat⟩, ⟨par1⟩)None
GEOMETRY.STTOUCHESRewritten(case ST_Touches(⟨spat⟩, ⟨par1⟩) when true then 1 when false then 0 else null end)::NUMERIC(1)None
GEOMETRY.STUNIONRewrittenST_union(⟨spat⟩, ⟨par1⟩)None
GEOMETRY.STWITHINRewritten(case ST_Within(⟨spat⟩, ⟨par1⟩) when true then 1 when false then 0 else null end)::NUMERIC(1)None
GEOMETRY.STXRewrittenST_X(case when geometryType(⟨spat⟩) !='POINT' then null else ⟨spat⟩ end)::DOUBLE PRECISIONNone
GEOMETRY.STYRewrittenST_Y(case when geometryType(⟨spat⟩) !='POINT' then null else ⟨spat⟩ end)::DOUBLE PRECISIONNone
GEOMETRY.TOSTRINGRewrittenST_AsText(⟨spat⟩)None
GEOMETRY.UNIONAGGREGATERewrittenST_Union(⟨p1⟩)None
GEOMETRY.ZRewrittenST_Z(case when geometryAType(⟨spat⟩)!='POINT' then null else ⟨spat⟩ end)::DOUBLE PRECISIONNone

System functions

The following table lists each source object in the System functions category and shows how DMS Schema Conversion converts it.

SourceConversionTargetAction item
@@ERROR in IF @@ERROR <> 0 whose body commits or rolls backRewrittenThe IF statement is replaced by PL/pgSQL exception handling; the @@ERROR test itself disappearsNone
@@ERROR in any other positionNot convertedNot applicable7811: PostgreSQL doesn't support the @@ERROR function. DMS SC skips this unsupported function in the converted code
@@IDENTITYRewrittenLASTVAL()None
@@ROWCOUNT after a SELECT used in an IF or PRINTRewrittensql$rowcount7834: Converted code of the @@rowcount function might produce different results compared to the source code
@@ROWCOUNT after an INSERT, UPDATE or DELETERewrittensql$rowcount, set by a GET DIAGNOSTICS sql$rowcount = ROW_COUNT; statement added before the reference7834: Converted code of the @@rowcount function might produce different results compared to the source code
@@ROWCOUNT in any other positionNot convertedNot applicable7833: DMS SC can't convert the @@rowcount function in the current context
@@TRANCOUNTNot convertedNot applicable7811: PostgreSQL doesn't support the @@TRANCOUNT function. DMS SC skips this unsupported function in the converted code
CONTEXT_INFONot convertedNot applicable7811: PostgreSQL doesn't support the CONTEXT_INFO function. DMS SC skips this unsupported function in the converted code
EDGE_ID_FROM_PARTSNot convertedNot applicable7933: DMS SC can't convert the EDGE_ID_FROM_PARTS system function of the SQL Graph database
GRAPH_ID_FROM_EDGE_IDNot convertedNot applicable7933: DMS SC can't convert the GRAPH_ID_FROM_EDGE_ID system function of the SQL Graph database
GRAPH_ID_FROM_NODE_IDNot convertedNot applicable7933: DMS SC can't convert the GRAPH_ID_FROM_NODE_ID system function of the SQL Graph database
NODE_ID_FROM_PARTSNot convertedNot applicable7933: DMS SC can't convert the NODE_ID_FROM_PARTS system function of the SQL Graph database
OBJECT_ID_FROM_EDGE_IDNot convertedNot applicable7933: DMS SC can't convert the OBJECT_ID_FROM_EDGE_ID system function of the SQL Graph database
OBJECT_ID_FROM_NODE_IDNot convertedNot applicable7933: DMS SC can't convert the OBJECT_ID_FROM_NODE_ID system function of the SQL Graph database

System objects views

The following table lists each source object in the System objects views category and shows how DMS Schema Conversion converts it.

SourceConversionTargetAction item
INFORMATION_SCHEMA.CHECK_CONSTRAINTSRenamedINFORMATION_SCHEMA.CHECK_CONSTRAINTSNone
INFORMATION_SCHEMA.COLUMNSExtension packaws_sqlserver_ext.INFORMATION_SCHEMA_COLUMNSNone
INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGERenamedINFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGENone
INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGERenamedINFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGENone
INFORMATION_SCHEMA.KEY_COLUMN_USAGEExtension packaws_sqlserver_ext.INFORMATION_SCHEMA_KEY_COLUMN_USAGENone
INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTSExtension packaws_sqlserver_ext.INFORMATION_SCHEMA_REFERENTIAL_CONSTRAINTSNone
INFORMATION_SCHEMA.ROUTINESExtension packaws_sqlserver_ext.INFORMATION_SCHEMA_ROUTINESNone
INFORMATION_SCHEMA.SCHEMATAExtension packaws_sqlserver_ext.INFORMATION_SCHEMA_SCHEMATANone
INFORMATION_SCHEMA.TABLESExtension packaws_sqlserver_ext.INFORMATION_SCHEMA_TABLESNone
INFORMATION_SCHEMA.TABLE_CONSTRAINTSExtension packaws_sqlserver_ext.INFORMATION_SCHEMA_TABLE_CONSTRAINTSNone
INFORMATION_SCHEMA.VIEWSExtension packaws_sqlserver_ext.INFORMATION_SCHEMA_VIEWSNone
SYS.ALL_COLUMNSExtension packaws_sqlserver_ext.SYS_ALL_COLUMNSNone
SYS.ALL_OBJECTSExtension packaws_sqlserver_ext.SYS_ALL_OBJECTSNone
SYS.ALL_VIEWSExtension packaws_sqlserver_ext.SYS_ALL_VIEWSNone
SYS.COLUMNSExtension packaws_sqlserver_ext.SYS_COLUMNSNone
SYS.DATABASESExtension packaws_sqlserver_ext.SYS_DATABASESNone
SYS.FOREIGN_KEYSExtension packaws_sqlserver_ext.SYS_FOREIGN_KEYSNone
SYS.FOREIGN_KEY_COLUMNSExtension packaws_sqlserver_ext.SYS_FOREIGN_KEY_COLUMNSNone
SYS.IDENTITY_COLUMNSExtension packaws_sqlserver_ext.SYS_IDENTITY_COLUMNSNone
SYS.INDEXESExtension packaws_sqlserver_ext.SYS_INDEXESNone
SYS.KEY_CONSTRAINTSExtension packaws_sqlserver_ext.SYS_KEY_CONSTRAINTSNone
SYS.OBJECTSExtension packaws_sqlserver_ext.SYS_OBJECTSNone
SYS.PROCEDURESExtension packaws_sqlserver_ext.SYS_PROCEDURESNone
SYS.SCHEMASExtension packaws_sqlserver_ext.SYS_SCHEMASNone
SYS.SP_SEQUENCE_GET_RANGEExtension packaws_sqlserver_ext.sp_sequence_get_range(⟨seq_name⟩, ⟨seq_range⟩)None
SYS.SQL_MODULESExtension packaws_sqlserver_ext.SYS_SQL_MODULESNone
SYS.SYSFOREIGNKEYSExtension packaws_sqlserver_ext.SYS_SYSFOREIGNKEYSNone
SYS.SYSINDEXESExtension packaws_sqlserver_ext.SYS_SYSINDEXESNone
SYS.SYSOBJECTSExtension packaws_sqlserver_ext.SYS_SYSOBJECTSNone
SYS.SYSPROCESSESExtension packaws_sqlserver_ext.SYS_SYSPROCESSESNone
SYS.SYSTEM_OBJECTSExtension packaws_sqlserver_ext.SYS_SYSTEM_OBJECTSNone
SYS.TABLESExtension packaws_sqlserver_ext.SYS_TABLESNone
SYS.TYPESExtension packaws_sqlserver_ext.SYS_TYPESNone
SYS.VIEWSExtension packaws_sqlserver_ext.SYS_VIEWSNone

System state

In the System state category, DMS Schema Conversion does not automatically convert any source objects. You must convert these objects manually. The following table lists these source objects.

SourceConversionTargetAction item
MSDB.DBO.SYSMAIL_HELP_STATUS_SPNot convertedNot applicable7900: PostgreSQL doesn't support functionality similar to SQL Server Database Mail
MSDB.DBO.SYSMAIL_START_SPNot convertedNot applicable7900: PostgreSQL doesn't support functionality similar to SQL Server Database Mail
MSDB.DBO.SYSMAIL_STOP_SPNot convertedNot applicable7900: PostgreSQL doesn't support functionality similar to SQL Server Database Mail

System statistical functions

In the System statistical functions category, DMS Schema Conversion does not automatically convert any source objects. You must convert these objects manually. The following table lists these source objects.

SourceConversionTargetAction item
@@CONNECTIONSNot convertedNot applicable7811: PostgreSQL doesn't support the @@CONNECTIONS function. DMS SC skips this unsupported function in the converted code
@@CPU_BUSYNot convertedNot applicable7811: PostgreSQL doesn't support the @@CPU_BUSY function. DMS SC skips this unsupported function in the converted code
@@IDLENot convertedNot applicable7811: PostgreSQL doesn't support the @@IDLE function. DMS SC skips this unsupported function in the converted code
@@IO_BUSYNot convertedNot applicable7811: PostgreSQL doesn't support the @@IO_BUSY function. DMS SC skips this unsupported function in the converted code
@@PACKET_ERRORSNot convertedNot applicable7811: PostgreSQL doesn't support the @@PACKET_ERRORS function. DMS SC skips this unsupported function in the converted code
@@PACK_RECEIVEDNot convertedNot applicable7811: PostgreSQL doesn't support the @@PACK_RECEIVED function. DMS SC skips this unsupported function in the converted code
@@PACK_SENTNot convertedNot applicable7811: PostgreSQL doesn't support the @@PACK_SENT function. DMS SC skips this unsupported function in the converted code
@@TIMETICKSNot convertedNot applicable7811: PostgreSQL doesn't support the @@TIMETICKS function. DMS SC skips this unsupported function in the converted code
@@TOTAL_ERRORSNot convertedNot applicable7811: PostgreSQL doesn't support the @@TOTAL_ERRORS function. DMS SC skips this unsupported function in the converted code
@@TOTAL_READNot convertedNot applicable7811: PostgreSQL doesn't support the @@TOTAL_READ function. DMS SC skips this unsupported function in the converted code
@@TOTAL_WRITENot convertedNot applicable7811: PostgreSQL doesn't support the @@TOTAL_WRITE function. DMS SC skips this unsupported function in the converted code

System procedures

The following table lists each source object in the System procedures category and shows how DMS Schema Conversion converts it.

SourceConversionTargetAction item
SYS.SP_EXECUTENot convertedNot applicable7672: PostgreSQL doesn't support EXECUTE statements that run a character string
SYS.SP_PREPARENot convertedNot applicable7672: PostgreSQL doesn't support EXECUTE statements that run a character string
SYS.SP_PREPEXECNot convertedNot applicable7672: PostgreSQL doesn't support EXECUTE statements that run a character string
SYS.SP_UNPREPARENot convertedNot applicable7672: PostgreSQL doesn't support EXECUTE statements that run a character string
SYS.SP_XML_PREPAREDOCUMENTExtension packaws_sqlserver_ext.sp_xml_preparedocument(⟨arg⟩)None
SYS.SP_XML_REMOVEDOCUMENTExtension packaws_sqlserver_ext.sp_xml_removedocumentNone

XML

In the XML category, DMS Schema Conversion does not automatically convert any source objects. You must convert these objects manually. The following table lists these source objects.

SourceConversionTargetAction item
XML.EXISTNot convertedNot applicable7708: DMS SC can't convert the usage of the unsupported XML.EXIST data type
XML.MODIFYNot convertedNot applicable7708: DMS SC can't convert the usage of the unsupported XML.MODIFY data type
XML.NODESNot convertedNot applicable7708: DMS SC can't convert the usage of the unsupported XML.NODES data type
XML.QUERYNot convertedNot applicable7708: DMS SC can't convert the usage of the unsupported XML.QUERY data type
XML.VALUENot convertedNot applicable7708: DMS SC can't convert the usage of the unsupported XML.VALUE data type