且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

Reverse Engineering Custom DataTypes -> GUID() in SQL Server to PostgreSQL

更新时间:2022-10-03 15:11:25

 原文 https://archive.sap.com/discussions/thread/3641585

 

First you reverse engineer from a script where the GUID is, into the PDM, there you should get an "internal" type CLS in the model.

 

this should be in mssql20???.xdb, if not you can add it(what i did in this example):

 

Reverse Engineering Custom DataTypes -> GUID() in SQL Server to PostgreSQL

 

then you create the model by changing the type to Postgres, where the internal type CLS should be translated to varchar(max)

and for that you need to add:

Reverse Engineering Custom DataTypes -> GUID() in SQL Server to PostgreSQL