locked
Relationship detection from SQL Azure Database RRS feed

  • General discussion

  • Hi there,

    I have a star schema implemented on SQL Server 2012 and migrated it to SQL Azure Database. Both schemas look fine. Relationships and FK look good to me.

    When I access the star schema in SQL Azure Database from Excel Powerpivot 2012 with the Table Import Wizard, the "Select related tables" function detects the related tables. Fine, so far. After the wizards finishes, the relationships are not available in the "Manage Relationship" window nor in the Diagram Viewer.

    When I access the star schema in SQL Server 2012, everthing works fine. Related tables are detected and the relationships are correct.

    Any idea?

    Thanks

    Peter

    Monday, August 13, 2012 4:55 PM

All replies