Toad World® Forums

Schema Compare failure


#1

Hi,
I tried to compare db with snapshot…

System.ApplicationException
Problem with load IndexesAndXMLIndexes
Stack Trace:
w Quest.Schema.MSSQL.Load.ModelLoader.Run(ICallBack callback)
w Quest.Schema.MSSQL.Load.ModelLoadManager.Loader.LoadModel(ICallBack callback)
w Quest.Schema.MSSQL.Load.ModelLoadManager.CreateInstance(ICallBack callback,
SchemaSnapshot snapshot, LoadModelOptions options)

w

Quest.Schema.MSSQL.Modules.Facade.SourcesLoaderModule.LoadModelFromSnapshot(ICallBack
callback, SourceLoader source)
w
Quest.Schema.MSSQL.Modules.Facade.SourcesLoaderModule.SourceLoader.Run(ICallBack
callback)

System.NullReferenceException
Odwołanie do obiektu nie zostało ustawione na wystąpienie obiektu.


#2

Hello Marcin,

Thank you for your attention,

Can you send me snapshot of the comparing database and comparing snapshot?
Sorry, I can’t reproduce this case without them.

Send them to vasiliy[dot]fofanov[at]quest[dot]com.


#3

Hello Marcin,

Thank you for your attention,
Can you send me snapshot of the comparing database and comparing snapshot?
Sorry, I can’t reproduce this case without them.
Send them to vasiliy[dot]fofanov[at]quest[dot]com.
[…]

Hi Vasiliy,
unfortunately, I cannot ;(. It contains some sensitive information [mainly in
stored procs/ triggers]
[company secrets]

Butter


#4

Hi Marcin,

If I add feature for cut bodies of stored procedures triggers and etc. from
snapshot you can sent in to me?
Problem in load Indexes and it doesn’t need bodies of objects.

Thanks for answer,

Vasiliy


#5

Hello, Marcin

Can you send snapshots of comparing databases to me
vasiliy[dot]fovanov[at]quest[dot]com? I can’t fix this bug without them.

I implement snapshot load limitation in Snapshot Load Wizard. Now you can
Exclude bodies of functions, views, procedures and triggers from snapshot

Use following steps for create limited diagnostic snapshot for Schema Compare
Support:


#6

Hello, Marcin

Can you send snapshots of comparing databases to me
vasiliy[dot]fovanov[at]quest[dot]com? I can’t fix this bug without them.

I implement snapshot load limitation in Snapshot Load Wizard. Now you can
Exclude bodies of functions, views, procedures and triggers from snapshot

Use following steps for create limited diagnostic snapshot for Schema Compare
Support:


#7

Hello, Marcin

Can you send snapshots of comparing databases to me
vasiliy[dot]fovanov[at]quest[dot]com? I can’t fix this bug without them.

I implement snapshot load limitation in Snapshot Load Wizard. Now you can
Exclude bodies of functions, views, procedures and triggers from snapshot

Use following steps for create limited diagnostic snapshot for Schema Compare
Support:
image003.png