Syncing logins between 2 IQ servers

[Former Member]

HI

I am in the process of moving IQ database from one server to new server. Would like to sync user logins. Unlike ASE, we canot BCP syslogins..

I came to know that Ron Watkins's script sp__gen_logins.

If any of you have that script , could you please provide me ..

or

is there any other procedures to syncing the passwords between two IQ servers .

Your help is very much appreciated.

Thanks in advance

Regards

Joga

[Former Member]

Hi

I developed a set of stored procedures that allow to generate DDL for various IQ objects, including logins. You can download the stored procedure for free from my website: http://www.gvirtz-consulting.com/downloads

Hope it helps

Leonid Gvirtz

[kimon_moschandreou]

excellent! Thank you very much for sharing

Kimon

[Former Member]

Thanks Very much Leonid  for your help.

Very much appreciated.

Regards

Joga

[kimon_moschandreou]

Hello,

obviously you are not using backup/restore. I think thiis is not possible, I am curious I someone appears with an answer. Also I am curious about this procedure you mention.

Regards,

Kimon