data replication

A web application is connecting to the centralized database server. The next thing i like to do is test the application using a local network connection to the local server. If assuming we have an internet available, how can i set up this network locally and have the data to submitted to the local database and then finally aggregate it to the central database?