Schema Modeler error

Data Abstract
1

Hi,
I got the error if SP link to another DB that is not include in DA Schema.

schema_error5

SP statement like as following. “Garment” DB & “yorkapp” DB are the same SQL server. Why need to sperate two DB? Reason is “Garment” DB is belong to vendor. I must not change the DB functions anymore such as Views and SP. So I need to using the other DB to keep my business logic in Views or SP.

SELECT ColorCode, Color = ltrim(upper(Color)), ChnColor, UDField2|
FROM Garment.dbo.Ma_Color (nolock)|
WHERE (ISNULL(UDField1, N’N’) <> ‘Y’)|

2

Hi,

can you confirm that this SQL can be opened with pure SDAC (i.e. w/o DA) w/o any issues, pls?

3

Hi,
It works in SDAC because I’m migrate the source to DA.

4

Hi,

I don’t see any issue with using another DB inside Schema Modeller:

animation

Can you create a simple testcase that reproduces this issue, pls?

5

Hi,
Sorry that I checked it is my fault. I haven’t attach the DB into SQL server. So it has the error. :sweat_smile:

1 Like