Is it totally crazy to think of creating a new Civi install (have one set up in Drupal 9 already) and merging a well-used Civi database into it, table by table? We've had our Civi install since around 2011 and the database is about 1.35gb and has about 22 thousand contacts. We can put in work to re-configure after moving, but I need to know if it's realistic to do it this way, as opposed to just moving the current database to the new install. We are looking to move to Drupal 8/9, from Drupal 7.
The reason is both the size of the database, so we can get rid of a bunch of unnecessary data, but after so many years there are many glitches and problems with the current database, probably more than I even know. I have started to make a list of what data is critical to move. I know there are many interconnected tables, but don't know enough details to know if something like this is realistic.