Integrate MySQL With Airtable using ASP.NET

Integrate MySQL With Airtable

1. Given a MySQL DB and a Table Prefix, Get a list of tables.
For Each table, Copy the table structure and all Records to AirTable.

2. Allow a bidirectional sync.


We need a Single Simple ASPX page.

Basic .ASPX file Please,
No "Code Behind"
No MVC
No Forms
No Dependencies
No Third party components



If the DB is "X"

And the list of tables is:
Table_A_01
Table_A_02
Table_A_03
Table_A_04
Table_B_01
Table_B_02
Table_B_03
Table_B_04
Table_C_01
Table_C_02
Table_C_03
Table_C_04

And Your input is ("X", "Table_B_"

Then you Sync:
Table_B_01
Table_B_02
Table_B_03
Table_B_04

Start by coping the Data from MySQL to AirTable

After the Initial Backup

We need a Compare fuction
Allow the user to select which row is newer
Then Sync

Also a Full "backup" Function

FROM MySQL
==================
Read a list of tables
For Each Table
Read all Rows/Fields
Update into AirTable in a Table with the same name
Next Table

And a Full "Restore" Option

FROM AirTable
==================
Read a list of tables
For Each Table
Read all Rows/Fields
Update into MySQL in a Table with the same name
Next Table