Multiple Gateway Scripting Projects

Not as long as you have a test database as well. I have a separate db for my test gateway, and use a DNS name in the connection, so I don't have to change my DB connections when restoring a backup. You can see more on that here

You may want to change your device connections to simulated ones as well, such as Programmable Device Simulator - Ignition User Manual 8.1 - Ignition Documentation (inductiveautomation.com)