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

Referencing objects from another database on the same server?

I have a database with enterprise data on it and will have to referencing the views/functions/tables into my application database.

How can I achieve this overcoming the 3-part naming restriction?
GenialArun
0

Comments

4 comments

  • Sergio R
    Rather than use the default option of using SQL Local DB, you can use a Temporary Database where those references will be valid
    Sergio R
    0
  • GenialArun

    Is there any sample that  I can refer to regarding cross database dependency handling?

    Your suggestion of using LocalDB is not clear to me.

    GenialArun
    0
  • Sergio R
    My suggestion was not using Local DB, which is the default option in SQL Change Automation.
    You should set a Temporary Database in a SQL Instance where those references are valid.
    Sergio R
    0
  • GenialArun
    How can we set the configuration for the automatic builds to target to a specific server instead of the LocalDB?
    GenialArun
    0

Add comment

Please sign in to leave a comment.