You have an on-premises Microsoft SQL server that uses the FileTables and Filestream features. You plan to migrate to Azure SQL. Which service should you use?
https://docs.microsoft.com/en-us/azure/azure-sql/migration-guides/database/sql-server-to-sql-database-overview?view=azuresql
If one of the following conditions applies to your business, consider moving to a SQL Server virtual machine (VM) instead:
You have strict dependency on features that are still not supported, such as FileStream/FileTable, PolyBase, and cross-instance transactions.
Your business might have requirements that make SQL Server on Azure Virtual Machines a more suitable target than Azure SQL Database.
You require direct access to the operating system or file system, such as to install third-party or custom agents on the same virtual machine with SQL Server.
You have strict dependency on features that are still not supported, such as FileStream/FileTable, PolyBase, and cross-instance transactions.
You need to stay at a specific version of SQL Server (2012, for example).
Your compute requirements are much lower than a managed instance offers (one vCore, for example), and database consolidation is not an acceptable option.
yes but as the answer explains, if you need to maintain the use of FileTable + Filestream in azure, it has to be on an SQL Server, wich has to ve on a VM(only possible setup to run SQL Server on azure). Azure sql or sql managed does't support it.
upvoted 1 times
...
...
This section is not available anymore. Please use the main Exam Page.DP-300 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
eric0718
Highly Voted 3 years agobingomutant
Most Recent 7 months, 2 weeks agoorionduo
1 year, 10 months agovictorlie
1 year, 10 months agoeleeitor
1 year, 7 months ago