Relational database conversion and purge
A computer implemented method, system and media are provided to convert relational database files hosted on a client server to operating database files. The operating database files are transferred using FTP protocol to a remote archival server. A relational database is created from the transferred operating database files on the remote archival server.
1. One or more computer storage media having computer-usable instructions that, when used by one or more computing devices, cause the one or more computing devices to perform a method for exporting and purging files from a relational database, the method comprising:
identifying the relational database files to be purged from a first server;
converting said relational database files into operating system files;
exporting said converted files in a batch via a network using file transfer protocol (ftp) to a remote server in a cloud computing network; and
purging said relational database files from the first server.
2. The media of claim 1 , wherein the relational database is a cache database.
3. The media of claim 1 , wherein the relational database files are electronic pharmacy records.
4. The media of claim 1 , wherein the relational database files are electronic medical records.
5. The media of claim 1 , wherein operating system files comprise on or more of extensible markup files (xml), extended metadata (xcd) files and unformatted text (txt) files.
6. The media of claim 1 , wherein operating system files comprises extensible markup files (xml), extended metadata (xcd) files and unformatted text (txt) files.
7. One or more computer storage media having computer-usable instructions that, when used by one or more computing devices, cause the one or more computing devices to perform a method for creating a relational database in a cloud computing network from importing operating system files, the method comprising:
installing a routine on a remote hosted server to import operating system files from a first server via a network and create a relational database with said operating system files;
beginning a terminal emulator for the relational database;
executing said routine to import said operating system files; and
executing said routine to create the relational database on the remote hosted server using said operating system files.
8. The media of claim 7 , wherein the relational database is a cache database.
9. The media of claim 7 , wherein the relational database files are electronic pharmacy records.
10. The media of claim 7 , wherein the relational database files are electronic medical records.
11. The media of claim 7 , wherein operating system files comprise on or more of extensible markup files (xml), extended metadata (xcd) files and unformatted text (txt) files.
12. The media of claim 7 , wherein operating system files comprises extensible markup files (xml), extended metadata (xcd) files and unformatted text (txt) files.
13. One or more computer storage media having computer-usable instructions that, when used by one or more computing devices, cause the one or more computing devices to perform a method for purging files from a relational database and creating a relational database from said purged files on a remote server, the method comprising:
identifying the relational database files to be purged from a first server;
converting said relational database files into operating system files;
exporting said converted files in a batch via a network using file transfer protocol (ftp) to a remote server in a cloud computing network;
purging said relational database files from the first server;
installing a routine on the remote hosted server to import operating system files from a first server via a network and create a relational database with said operating system files;
beginning a terminal emulator for the relational database;
executing said routine to import said operating system files; and
executing said routine to create the relational database on the remote hosted server using said operating system files.
14. The media of claim 13 , wherein the relational database is a cache database.
15. The media of claim 13 , wherein the relational database files are electronic pharmacy records.
16. The media of claim 13 , wherein the relational database files are electronic medical records.
17. The media of claim 13 , wherein operating system files comprise on or more of extensible markup files (xml), extended metadata (xcd) files and unformatted text (txt) files.
18. The media of claim 13 , wherein operating system files comprises extensible markup files (xml), extended metadata (xcd) files and unformatted text (txt) files.
19. The media of claim 18 , further comprising:
creating Structured Query Language files from the relational database on the remote hosted server using said operating system files; and
creating structured query language files from files not purged from the first server.
20. The media of claim 19 , further comprising:
running reports on the structure query language files from both the remote hosted server and the first server.