Disabling the Stretch DB features for a database and the tables stops data migration immediately and queries don't include remote data anymore. You can copy the already-migrated data back to the local system, or you can leave it in Azure. As with Stretch Database enabling, you can disable it for tables and databases using SSMS and Transact-SQL. In order to disable Stretch DB for a database, you have to disable it for tables involved in stretching. Otherwise, you will get an error that instructs you to disable stretch tables before that action.