Schema not recognised

ronaldvanhelden · November 19, 2015 3:30AM

Hi,

I have two equal databases on the same server but DLM does not recognise that the databases are the same.
I did a SQL compare with every ignore option off, and without object filtering and tells me the databases are exactly the same.

Rob C · November 23, 2015 5:53AM

Hi Ronald,

What status are the databases currently shown as? Are they red, i.e. drifted, or are they green, i.e. acknowledged?

ronaldvanhelden · November 23, 2015 6:24AM

They are currently in drifted because i made the same change on both databases (so they are still the same), i did that so i could get the debug files (h x2)

Rob C · November 23, 2015 6:41AM

If you acknowledge the schema for one database and enter a schema name, does the other database go orange and display the schema name to reflect that the schema is known?

ronaldvanhelden · November 23, 2015 6:50AM

No, the first database will change to the named scheme, the other database remains in drifted state

Rob C · November 23, 2015 6:55AM

Could there be differences in column order? DLM Dashboard will treat these as differences, but SQL Compare ignores them by default. Try doing a comparion using SQL Compare but with the Force column order option enabled. Does that detect any differences?

ronaldvanhelden · November 23, 2015 6:58AM

I have tried with sql compare with the force column order option, but the databases are still equal

Rob C · November 24, 2015 9:48AM

Hi Ronald,

I have created a support ticket for you and you should receive an email shortly.

carthorn · May 25, 2016 11:21AM

Was this ever resolved, I'm having the same issue. SQL Compare has no differences but says that one of my databases has drifted.

josh_stcu · October 10, 2017 10:26PM

I am experiencing this problem still as well.

Tianjiao_Li · October 19, 2017 12:53PM

I'm sorry to say it's a known issue where DLM Dashboard incorrectly detects differences because sub-objects in the two databases are being scripted in different orders. However, we have not been able to prioritize it for bug fixing.

Schema not recognised

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk