Moving Multisite to testing Server IP

I am moving a multisite with 18 websites to a VPS.
The VPS has a dedicated IP,. The site domain name has a separate dedicated IP.
Since the live domain is still active, I would like to make changes to the testing server site before we change the DNS pointers.
Therefore, I have replaced the domain name in the tables with the (to be transferred) domain's dedicated IP address, using a global search and replace.
The code sees the database, but we get the message"Could not find site Searched for table wplcb_blogs in database..."
It is searching in the correct database and the table is in there.
Is there a better way to do what I am trying to do?
Thank you.