Hello Dr. Carcamo,
I see that you have already installed AC 6.0.10 on the new server.
Here are the steps to follow to move the database over to the new server.
1. On your existing server, run a ?Full Backup?. Meaning you want to open the Backup Utility, click on the Advanced Settings button and make sure Exclude Imported Items and Exclude Images are both Unchecked.
2. Run the backup, when the backup is complete you can find it in the Backup folder that is inside the Amazing Charts folder on the existing server. The backup file will have your practice name followed by some numbers and ending in .enc. Make sure you find the one you just ran. It will have today?s date and the time the backup file was completed.
3. Now you need to get that file over to the new server. You can either browse across the network to find it or place it on a thumb drive and move it over manually.
4. Once you have the backup .enc file on the new server, you will need to restore that backup. Before you do this you need to have started Amazing Charts, created a practice by entering in the practice name, address etc. and created a user account (with the Level Of Access of Highest: Provider) This does not have to be real practice and user information as you will be overwriting it with the restore. You can just click next through the ?add a schedule? part. Also remember the Admin and User passwords, you will need them. Then start Amazing Charts and log in as the user you created. This will attach the database to the SQL Server.
5. Now to restore the backup database you will need to run the Backup Restore Utility. This can be found in the Amazing Charts Directory folder and has a red icon that looks like a ship?s life saver. Run the backup restore utility and brows to the backup .enc file that you moved over from the original server. When you run the utility it may ask you to enter in the Admin password that you created. Once the restore utility has finished, your database has been moved to the new server. Now you just need to run the 6.0.10 database tuner to upgrade the database.
6. If you have any lab interfaces or other interfaces that have placed a folder inside the Amazing Charts Directory folder on the old server, you will need to move those over to Amazing Charts Directory folder on the new server. Then contact the lab company to have them redirect the data they send to you over to the new server.
7. You will need to share out the Amazing Charts Directory folder on the new server giving the Everyone group ?Full Control?. Also if you are running a firewall on the new server, you need to make a port exception to allow port 61067 for both TCP and UDP. If you need help with this we have a video on our website, here is the link
http://amazingcharts.com/support/i-want-to-help-myself/video-tutorials/. Just click on the ?Opening Firewall Ports? link.
8. Then un-share the Amazing Charts Directory folder on the old server so none of the local computers can read or write to the old database. When you restart Amazing Charts on the local computers they will make you browse to the new server to connect to the database. Also make sure you reset the path on the old server so it is reading and writing data to the new server. You may even want to disable the SQL Server (AmazingCharts) service on the old server once everything is done. This will avoid any possibility of accidentally adding data to the incorrect database.
I hope this helps you out, if you have any issues with the move please do not hesitate to contact AC technical Support for help.
Thank you,
Anthony@AC
