I have an extended events .xel file on my local machine that I'm trying to export as a table to an Azure SQL DB, using the extended events export wizard in SSMS v18.2.
I can connect to the database and the table object is created, however it is not populated with any data.
the error message i get is:
Cannot access destination table '[azuresqldb-name].[dbo].[will-xEvents-test]'. (System.Data)
Reference to database and/or server name in 'azuresqldb-name.dbo.will-xEvents-test' is not supported in this version of SQL Server. (Microsoft SQL Server, Error: 40515)
any suggestions for a work around?