Import from SQL to Supabase
Hello there! I have a SQL Server database that is modified every three months (some rows are erased). So far I ran a query in SQL, downloaded and stored the Excel files (no more than 5 MB each, in total 20 MB annually) but I don't want to make it manually.
I need a way to automatically import the original data into supabase. I want to query the last three months of data, and add it to the online database automatically (some kind of Cron job or something similar).
What would be the easiest option? Thanks in advance!
I need a way to automatically import the original data into supabase. I want to query the last three months of data, and add it to the online database automatically (some kind of Cron job or something similar).
What would be the easiest option? Thanks in advance!
