Working on a database compatibility tool. So your app works on SQL Server 2022 on-prem, but does it work on Azure SQL DB, AWS RDS, GCP CloudSQL, etc?
These cloud flavours have a compatible SQL dialect, but it's often details like missing features (CDC and Auditing on RDS are good examples) or differences in system objects that make it difficult to support your app on these platforms.
I capture all sql statements, run them through multiple SQL parsers to find all the system objects your app is using (tables, functions, stored procedures, etc). I then check them all against a catalog I have built of all system objects for every version of SQL Server on every platform.
I then give a report to see which platforms your app will work on, which ones it wont work on and which system objects are the problem.
Other database engines will be added once I get it working end to end (almost there).
These cloud flavours have a compatible SQL dialect, but it's often details like missing features (CDC and Auditing on RDS are good examples) or differences in system objects that make it difficult to support your app on these platforms.
I capture all sql statements, run them through multiple SQL parsers to find all the system objects your app is using (tables, functions, stored procedures, etc). I then check them all against a catalog I have built of all system objects for every version of SQL Server on every platform.
I then give a report to see which platforms your app will work on, which ones it wont work on and which system objects are the problem.
Other database engines will be added once I get it working end to end (almost there).