How can I copy the user profile settings of one user to another across multiple databases

Often when setting up a new user you'd like to be able to easily set the custom user profile of the new user based on the profile of another user.  Jiwa has offered a script to do this for years (see below for a reminder). 

But what about the profile of another use in another database?  Or the same user in another database?  For example, when deploying a new installation, the users have already set up their profiles in the test system - their custom columns and custom tabs.

Instead of replicating all these changes again in the live system, we can now easily copy the settings to the same or different user in a different database.  As long as both databases are on the same SQL Server, which they tend to be in the case of test/live systems.

Step-by-step guide



  1. Set up your template user in one database.

  2. Open the script attached in SQL.

  3. Define your source username and database, and destination username and database in the User Definable section

    1. Leave the database name inside the brackets

  4. Run the script.

 



For those of you who need a reminder, here is the pre-existing script that copies the user profile of one user to another user, within the same database.

It can be found here in any Jiwa 7 installation: C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Miscellaneous SQL Scripts\General



Warning

Beware: This script will over-write any existing settings for the destination username



Tip

Leave the database name inside [ brackets ] when setting the User Definable section

Related articles



DEV-8987: Ability to apply user custom column settings from one database to another for the same usernamePassed Testing