Did you know...
Moving a User from One Database to Another
The following procedure describes how to move one or more users’ data from one Synchronize database to another. CrossWind recommends that you make a backup of your database before proceeding.
- If you have not already done it, install the Synchronize server and database on the target machine and add the necessary Synchronize user account(s) for the user(s) being moved.
- If the two databases involved share information with each other or with other Synchronize servers via the distributed databases mechanism, make sure that you have set up the
db/domains file and that multi-database functionality is working correctly before proceeding.
Obtain the sy_mover utility and its instructions from the
http://www.crosswind.com/products/synchronize/ admintools/sy_mover subdirectory on CrossWind’s FTP server.
Use the sy_mover utility to move each user from the source database to the target database. See the instructions for sy_mover for details on various options and restrictions. If you have many users to move, you could simply put the list of names into a file (for example, /tmp/myusers) and execute a script such as:
#!/bin/sh
for user in `cat /tmp/myusers`
do
sy_mover -from soapstone -to tetraploid -user "$user"
done
This script assumes that the list of users contains only the Synchronize_name for each. If you made a copy of the db/users file for this purpose, then you will either need to edit it so that only the Synchronize_name appears, or you will need to modify this script to accommodate the more complicated format.
After you have verified that users’ data has been correctly transferred, remove their names from the db/users file in the source database.
|