Activity overview
Latest activity by rgben
Hey, so I made a workaround for this recently. I was not working on this for a while, but when I returned, I had a new idea. It is a little tedious, but it works wonderfully. I do a Select * Into NewTableName From ExternalTableName to copy all data from the External Table into a "real" table in the database. Then I can use the Data Compare tool against the two "real" tables. It works! So, I will need to use this technique table by table, but that is ultimately a great solution for people with a small table count. And in the case of one of my sample tables, I was comparing 400 columns' data, so the tool was still extremely helpful! / comments
Hey, so I made a workaround for this recently. I was not working on this for a while, but when I returned, I had a new idea. It is a little tedious, but it works wonderfully.I do a Select * Into Ne...
I got an extension and connected to the Azure Synapse on-demand instance using authentication type Active Directory universal with MFA. Everything seemed to go well, but I do not think Data Compare can properly list the databases in Azure Synapse. I got an error message: 'sysdatabases' is not supported. I think Data Compare is trying to query a sysdatabases object (to populate the Database drop-down menu) which does not exist in Synapse apparently. / comments
I got an extension and connected to the Azure Synapse on-demand instance using authentication type Active Directory universal with MFA.Everything seemed to go well, but I do not think Data Compare ...
Thanks, Dan, for getting back with me. It sounds like I may be able to connect to the Azure Synapse Lake Database, which is the source for the External Tables in the Azure SQL Database. Not a bad idea [image] I think my trial has expired, though, so I cannot confirm it will work. / comments
Thanks, Dan, for getting back with me. It sounds like I may be able to connect to the Azure Synapse Lake Database, which is the source for the External Tables in the Azure SQL Database.Not a bad id...
Does SQL Data Compare support External Tables?
I need to compare External Tables in an Azure SQL Database with "standard" tables in the same database. Does SQL Data Compare work with External Tables? I do not see them in the list of tables.