SQL Remote User's Guide
Deploying and Synchronizing Databases
Synchronizing databases
In many installations, the consolidated server will be running on a different operating system than the remote databases.
Adaptive Server Anywhere databases can be copied from one file or operating system to another. This allows you flexibility in how you carry out your initial synchronization of databases.
For example, you may be running an Adaptive Server Enterprise server on a UNIX system that holds the consolidated database, but wish to deploy remote databases on laptop computers running some flavor of Windows.
In this circumstance, you have several options for the platforms on which you extract the database, including the following, assuming you have the requisite software:
Run the extraction utility on UNIX to create the reload script and data files. Copy the script and data files to a Windows machine. Create the Adaptive Server Anywhere databases and load them up with the schema and data on Windows.
Run the extraction utility on UNIX to create the reload script and data files. Create the Adaptive Server Anywhere databases and load them up with the schema and data on the same UNIX platform, and then copy the database files onto Windows machines for deployment.
Run the extraction utility on Windows, and carry out all database creation and other tasks on the Windows operating system.