When moving the site, you will have to also move the database. this means a new database would need to be created on the new server and the tables from the old server recreated through an export of the old database tables and import to the new database.
also, you would need to edit the database connection details so it is connecting to the new server.
if the insert isn't working, my suspicion is that the connection has not been updated or the tables dont exist.