none
Build error due to OPENQUERY RRS feed

  • Question

  • I'm using OPENQUERY in some views and procs to access PostgreSQL databases. 

    I cannot perform a SSDT schema compare however as there are "unresolved references" to the linked server name.

    How do I get around the errors?



    http://sqlninja.blogspot.com/


    Tuesday, April 24, 2012 4:18 AM

Answers

  • I presume you're trying to resolve unresolved references appearing before build in your project, correct?

    You should be able to deal with the unresolved references by adding a LinkedServer item to the project.  If you wish to include the LinkedServer in the comparison you'll need to update the Object types tab of the schema compare options to include Linked Server objects.


    Jeff

    • Proposed as answer by Janet Yeilding Wednesday, April 25, 2012 5:36 PM
    • Marked as answer by Scott Herbert Wednesday, April 25, 2012 11:12 PM
    Tuesday, April 24, 2012 11:58 PM

All replies

  • I presume you're trying to resolve unresolved references appearing before build in your project, correct?

    You should be able to deal with the unresolved references by adding a LinkedServer item to the project.  If you wish to include the LinkedServer in the comparison you'll need to update the Object types tab of the schema compare options to include Linked Server objects.


    Jeff

    • Proposed as answer by Janet Yeilding Wednesday, April 25, 2012 5:36 PM
    • Marked as answer by Scott Herbert Wednesday, April 25, 2012 11:12 PM
    Tuesday, April 24, 2012 11:58 PM
  • Spot on, thanks.

    http://sqlninja.blogspot.com/

    Wednesday, April 25, 2012 11:12 PM