Skip to Content
0

About login migrations betwwen versions

Aug 08, 2017 at 05:14 PM

49

avatar image
Former Member

Hi masters .

I want to migrate the user logins from an ASE 12.5 to a ASE 15.7 . Can I do it with bcp or with the create insert statements from the DB Artisan or i need to use some tool ? I don´t know if the syslogins structire are the sam ? and I have no access yet to the 12.5 version, only to the 15.7

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Avinash Kothare Aug 08, 2017 at 05:55 PM
0

SAFE : Extract logins from old server with SAP tools like ddlgen or third party tool like dbartisan

You will have to edit the SQL for passwords

Then run the updated SQL on the new server.

If you are interested only in syslogins port : following method is typically used for getting syslogins rows from old version to new version

1. On old server crate a view with additional columns needed in syslogins per new version

2. From old server bcp out -- using the view above -- in character mode

3. New server create empty table in tempdb matching new syslogins columns

4. New serve bcp in to tempdb table created above from the file created in #2

5. New server turn "allow updates" on with sp_configure

6. New server in a transaction : insert required rows (excluding names sa, probe) into master..syslogins select from tempdb..table created above

commit transaction ( if things went as expected ) or rollback (if they did not go as expected)

7. New server disable allow updates with sp_configure.

NOTE: syslogins is just one part of the security. There are other related system tables which will not automatically get migrated.

HTH

Avinash

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Ok, I willl try

Thank´s a lot

0