Skip to main content
Question

Use tables from one project in another project (from the same database)

  • May 29, 2020
  • 1 reply
  • 0 views
M

We have multiple TimeXtender projects that use the same databases for their ODX/DSA/MDWs.

What is the best way to use tables from one project in another one of the other projects? "Add External SQL Connection" seems to be an option, should this still be used if the table we want to connect to is in the same database?

    1 reply

    J
    • JTreadwell
    • Community Manager
    • 152 replies
    • May 30, 2020

    Hi Mark, Thanks for posting. 

    Yes, External SQL Connection is absolutely the best option. If they are in the same db, this option will simply create views making it very efficient. 

    Just a tip If you are taking this approach. I'd highly recommend using different schemas in your different projects to prevent table naming collisions. 

    Reply


    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept or continue browsing you agree to our cookie policy. Learn more about our cookies.

     
    Cookie settings