In many cases a database needs to be deployed with data pre-populated in some tables. Loading static data into tables that are referenced from other tables is a common case – examples might be customer types, address types, data states, etc.
Post by this author
SQL Azure has recently introduced support for federated databases which enables an elastic scale-out solution in the cloud. SQL Azure Federations introduces new syntax and management behaviors that are not currently supported by SSDT. Support for federated databases will be added in a future release of SSDT.