Subject | Re: migration of the users |
---|---|
Author | Dmitry Kalugin |
Post date | 2005-03-14T06:43:17Z |
Hello, Ricardo!
Sunday, March 13, 2005, 5:32:20 AM, you wrote:
RM> Hello folks, I'm new in the group. How can I the migration of the
RM> useres from one FIB server to a new FIB server?
1 connect to source "fbclient.fdb"
2 execute Query
SELECT
USERS.USER_NAME,
USERS.SYS_USER_NAME,
USERS.GROUP_NAME,
USERS.UID,
USERS.GID,
USERS.PASSWD,
USERS.PRIVILEGE,
USERS.COMMENT,
USERS.FIRST_NAME,
USERS.MIDDLE_NAME,
USERS.LAST_NAME,
USERS.FULL_NAME
FROM USERS
3 create insert script from previos query[2]
4 connect to destination "fbclient.fdb"
5 execute previos[3] insert script
--
Best regards,
Dmitry Kalugin
Ukraine, Donetsk
ICQ177363
Sunday, March 13, 2005, 5:32:20 AM, you wrote:
RM> Hello folks, I'm new in the group. How can I the migration of the
RM> useres from one FIB server to a new FIB server?
1 connect to source "fbclient.fdb"
2 execute Query
SELECT
USERS.USER_NAME,
USERS.SYS_USER_NAME,
USERS.GROUP_NAME,
USERS.UID,
USERS.GID,
USERS.PASSWD,
USERS.PRIVILEGE,
USERS.COMMENT,
USERS.FIRST_NAME,
USERS.MIDDLE_NAME,
USERS.LAST_NAME,
USERS.FULL_NAME
FROM USERS
3 create insert script from previos query[2]
4 connect to destination "fbclient.fdb"
5 execute previos[3] insert script
--
Best regards,
Dmitry Kalugin
Ukraine, Donetsk
ICQ177363