Source Controlled Database to New Database Comparison Issues

claire.thomson

OK...

I have a database under source control

it had a view which previously used a linked server say 'LinkedA'

I changed the linked server to a new one say 'LinkedB'

I'm now trying to compare that database to create a new database with the same schema - but it is picking up on all the old commits!

keeps failing telling me I don't have linked server 'LinkedA' - which is true, but why is it trying to do this!? I can see from the script it's generating the original view and then applying alter statements later on

If I create a new database and link it to source control (which I don't want) it works as expected.

if I'm comparing database to database - why is it even looking at the source control?

Anu D

Hi Claire,

Thanks for your post.

So the database you are comparing do not have reference to Linked server A but now points to Linked server B?

claire.thomson

Yes that's correct Anu.

Any ideas?

Thanks