How can we help you today? How can we help you today?

Source Controlled Database to New Database Comparison Issues

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?
claire.thomson
0

Comments

2 comments

Sort by
  • 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?
    Anu D
    0
  • claire.thomson
    Yes that's correct Anu.

    Any ideas?

    Thanks
    claire.thomson
    0

Add comment

Please sign in to leave a comment.