Apache::DBI describes itself as "absolutely transparent". In theory there should be no impact of using plain DBI if there are no forks or threads involved.

In practice you might find out that the module was required for a particular reason and you might need to touch the code in order to upgrade to the successor DBIx::Connector.