Here are some little issues:
• Selecting a Profile always revert to an “SQL Login” Authentication type … “Microsoft Entra ID – Universal with MFA support” is expected.
• A batch should not only be allowed to have one statement on scripts. For example, it is possible that some variables may be needed if you are trying to populate a table. Alternatively, allow the script not to be executed (is not clear how to do this). In VS the Database Projects allow for such…
• It will be nice to add support for VS Database Projects to publish to Fabric… I tried and was clear how to…
More important...
While publishing it outputted an issue while failing to deploy the dacpac:
Error: Could not deploy package. Error SQL0: Deployment cannot continue because table changes that require ‘ALTER TABLE’ are not supported on Synapse Data Warehouse in Microsoft Fabric at this time.
That I know is not true since I can execute the scripts that do have those 'ALTER TABLE'(s) without any issues and I get the expected results in the Fabric Data Warehouse.
