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 ..
is there any other procedures to syncing the passwords between two IQ servers .
Your help is very much appreciated.
Thanks in advance
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