In many cases it should be fine to point them all at the same server. You’ll just need to make sure there aren’t any collisions between schema/table names.