What options do I have to transfer an Azure SQL DB (v12, sql 2014) to an on-premise sql 2008 DB?
Assume that the Azure DB began life as a sql 2008 DB and no changes were made to it (schema wise) that would affect that sql compatibility of the two DBs.
TIA,
edm2
P.S While I understand SSIS data transfer is an option, that requires a customized SSIS package for each DB transfer. And the data needs to be transferred in just the right order because of PK\FK constraints. This approach seems adhoc and time consuming,
best avoided, if possible.