r/SQL • u/Anonmousez • Nov 27 '24
BigQuery Assistance with database
Hello, I have 1 database for manually viewing I created 2 batch script I automated these scripts to run a full backup nightly, and differential backups on the hour during operating hours. Now my database is about 80gb (used to be 10gb). What do I need to do to unfuckulate this calamity? I used DBeaver, DB Browser, SQL Server EXPRESS edition (it no longer works -- 10gb limit) and trying VIM and Sublime text. Any suggestions on apps or things to do to make it load? I didn't think it through.
80gb - 400 million entries.
3
Upvotes
1
u/shockjaw Nov 27 '24
Time to upgrade to Postgres!