{"id":2332,"date":"2018-08-29T13:47:47","date_gmt":"2018-08-29T13:47:47","guid":{"rendered":"http:\/\/dbtut.com\/?p=2332"},"modified":"2018-11-24T14:55:55","modified_gmt":"2018-11-24T14:55:55","slug":"how-to-move-logins-to-another-instancesp_help_revlogin","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/08\/29\/how-to-move-logins-to-another-instancesp_help_revlogin\/","title":{"rendered":"How To Move Logins To Another Instance(sp_help_revlogin)"},"content":{"rendered":"

 <\/p>\n

If you do not use a contained database, you must also move your logins when you move the database to another instance.<\/p>\n

You can find detailed information about the Contained Database in the article “What is Contained Database and How To Create<\/a>“.<\/p>\n

You can use the script below to move the logins to another instance.<\/p>\n

I use this script. The script create two sp. You will use the first one when you want to transfer logins.<\/p>\n

Its called sp_help_revlogin.<\/p>\n

And you can find the same script in Microsofts site. I will share it at the end of article.<\/p>\n

USE [master]\r\nGO\r\n\/****** Object:\u00a0 StoredProcedure [dbo].[sp_help_revlogin]\u00a0\u00a0\u00a0 Script Date: 8\/27\/2018 6:01:36 PM ******\/\r\nSET ANSI_NULLS ON\r\nGO\r\nSET QUOTED_IDENTIFIER ON\r\nGO\r\nCREATE PROCEDURE [dbo].[sp_help_revlogin] @login_name sysname = NULL AS\r\nDECLARE @name sysname\r\nDECLARE @type varchar (1)\r\nDECLARE @hasaccess int\r\nDECLARE @denylogin int\r\nDECLARE @is_disabled int\r\nDECLARE @PWD_varbinary\u00a0 varbinary (256)\r\nDECLARE @PWD_string\u00a0 varchar (514)\r\nDECLARE @SID_varbinary varbinary (85)\r\nDECLARE @SID_string varchar (514)\r\nDECLARE @tmpstr\u00a0 varchar (1024)\r\nDECLARE @is_policy_checked varchar (3)\r\nDECLARE @is_expiration_checked varchar (3)\r\nDECLARE @defaultdb sysname\r\nIF (@login_name IS NULL)\r\n\u00a0 DECLARE login_curs CURSOR FOR\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 SELECT p.sid, p.name, p.type, p.is_disabled, p.default_database_name, l.hasaccess, l.denylogin FROM\r\nsys.server_principals p LEFT JOIN sys.syslogins l\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 ON ( l.name = p.name ) WHERE p.type IN ( 'S', 'G', 'U' ) AND p.name <> 'sa'\r\nELSE\r\n\u00a0 DECLARE login_curs CURSOR FOR\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 SELECT p.sid, p.name, p.type, p.is_disabled, p.default_database_name, l.hasaccess, l.denylogin FROM\r\nsys.server_principals p LEFT JOIN sys.syslogins l\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 ON ( l.name = p.name ) WHERE p.type IN ( 'S', 'G', 'U' ) AND p.name = @login_name\r\nOPEN login_curs\r\n\r\nFETCH NEXT FROM login_curs INTO @SID_varbinary, @name, @type, @is_disabled, @defaultdb, @hasaccess, @denylogin\r\nIF (@@fetch_status = -1)\r\nBEGIN\r\n\u00a0 PRINT 'No login(s) found.'\r\n\u00a0 CLOSE login_curs\r\n\u00a0 DEALLOCATE login_curs\r\n\u00a0 RETURN -1\r\nEND\r\nSET @tmpstr = '\/* sp_help_revlogin script '\r\nPRINT @tmpstr\r\nSET @tmpstr = '** Generated ' + CONVERT (varchar, GETDATE()) + ' on ' + @@SERVERNAME + ' *\/'\r\nPRINT @tmpstr\r\nPRINT ''\r\nWHILE (@@fetch_status <> -1)\r\nBEGIN\r\n\u00a0 IF (@@fetch_status <> -2)\r\n\u00a0 BEGIN\r\n\u00a0\u00a0\u00a0 PRINT ''\r\n\u00a0\u00a0\u00a0 SET @tmpstr = '-- Login: ' + @name\r\n\u00a0\u00a0\u00a0 PRINT @tmpstr\r\n\u00a0\u00a0\u00a0 IF (@type IN ( 'G', 'U'))\r\n\u00a0\u00a0\u00a0 BEGIN -- NT authenticated account\/group\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 SET @tmpstr = 'CREATE LOGIN ' + QUOTENAME( @name ) + ' FROM WINDOWS WITH DEFAULT_DATABASE = [' + @defaultdb + ']'\r\n\u00a0\u00a0\u00a0 END\r\n\u00a0\u00a0\u00a0 ELSE BEGIN -- SQL Server authentication\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 -- obtain password and sid\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SET @PWD_varbinary = CAST( LOGINPROPERTY( @name, 'PasswordHash' ) AS varbinary (256) )\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 EXEC sp_hexadecimal @PWD_varbinary, @PWD_string OUT\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 EXEC sp_hexadecimal @SID_varbinary,@SID_string OUT\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 -- obtain password policy state\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SELECT @is_policy_checked = CASE is_policy_checked WHEN 1 THEN 'ON' WHEN 0 THEN 'OFF' ELSE NULL END \r\nFROM sys.sql_logins WHERE name = @name\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SELECT @is_expiration_checked = CASE is_expiration_checked WHEN 1 THEN 'ON' WHEN 0 THEN 'OFF' ELSE NULL END \r\nFROM sys.sql_logins WHERE name = @name\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SET @tmpstr = 'CREATE LOGIN ' + QUOTENAME( @name ) + ' WITH PASSWORD = ' + @PWD_string + ' HASHED, \r\nSID = ' + @SID_string + ', DEFAULT_DATABASE = [' + @defaultdb + ']'\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 IF ( @is_policy_checked IS NOT NULL )\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 BEGIN\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SET @tmpstr = @tmpstr + ', CHECK_POLICY = ' + @is_policy_checked\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 END\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 IF ( @is_expiration_checked IS NOT NULL )\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 BEGIN\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SET @tmpstr = @tmpstr + ', CHECK_EXPIRATION = ' + @is_expiration_checked\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 END\r\n\u00a0\u00a0\u00a0 END\r\n\u00a0\u00a0\u00a0 IF (@denylogin = 1)\r\n\u00a0\u00a0\u00a0 BEGIN -- login is denied access\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 SET @tmpstr = @tmpstr + '; DENY CONNECT SQL TO ' + QUOTENAME( @name )\r\n\u00a0\u00a0\u00a0 END\r\n\u00a0\u00a0\u00a0 ELSE IF (@hasaccess = 0)\r\n\u00a0\u00a0\u00a0 BEGIN -- login exists but does not have access\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 SET @tmpstr = @tmpstr + '; REVOKE CONNECT SQL TO ' + QUOTENAME( @name )\r\n\u00a0\u00a0\u00a0 END\r\n\u00a0\u00a0\u00a0 IF (@is_disabled = 1)\r\n\u00a0\u00a0\u00a0 BEGIN -- login is disabled\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 SET @tmpstr = @tmpstr + '; ALTER LOGIN ' + QUOTENAME( @name ) + ' DISABLE'\r\n\u00a0\u00a0\u00a0 END\r\n\u00a0\u00a0\u00a0 PRINT @tmpstr\r\n\u00a0 END\r\n\u00a0 FETCH NEXT FROM login_curs INTO @SID_varbinary, @name, @type, @is_disabled, @defaultdb, @hasaccess, @denylogin\r\n\u00a0\u00a0 END\r\nCLOSE login_curs\r\nDEALLOCATE login_curs\r\nRETURN 0\r\nGO\r\n\r\nUSE [master]\r\nGO\r\n\/****** Object:\u00a0 StoredProcedure [dbo].[sp_hexadecimal]\u00a0\u00a0\u00a0 Script Date: 8\/27\/2018 6:02:38 PM ******\/\r\nSET ANSI_NULLS ON\r\nGO\r\nSET QUOTED_IDENTIFIER ON\r\nGO\r\nCREATE PROCEDURE [dbo].[sp_hexadecimal]\r\n\u00a0\u00a0\u00a0 @binvalue varbinary(256),\r\n\u00a0\u00a0\u00a0 @hexvalue varchar (514) OUTPUT\r\nAS\r\nDECLARE @charvalue varchar (514)\r\nDECLARE @i int\r\nDECLARE @length int\r\nDECLARE @hexstring char(16)\r\nSELECT @charvalue = '0x'\r\nSELECT @i = 1\r\nSELECT @length = DATALENGTH (@binvalue)\r\nSELECT @hexstring = '0123456789ABCDEF'\r\nWHILE (@i <= @length)\r\nBEGIN\r\n\u00a0 DECLARE @tempint int\r\n\u00a0 DECLARE @firstint int\r\n\u00a0 DECLARE @secondint int\r\n\u00a0 SELECT @tempint = CONVERT(int, SUBSTRING(@binvalue,@i,1))\r\n\u00a0 SELECT @firstint = FLOOR(@tempint\/16)\r\n\u00a0 SELECT @secondint = @tempint - (@firstint*16)\r\n\u00a0 SELECT @charvalue = @charvalue +\r\n\u00a0\u00a0\u00a0 SUBSTRING(@hexstring, @firstint+1, 1) +\r\n\u00a0\u00a0\u00a0 SUBSTRING(@hexstring, @secondint+1, 1)\r\n\u00a0 SELECT @i = @i + 1\r\nEND\r\nSELECT @hexvalue = @charvalue\r\nGO\r\n<\/pre>\n
 <\/p>\n
https:\/\/support.microsoft.com\/en-us\/kb\/246133<\/a><\/p>\n
 <\/p>\n
This script creates two stored procedures in your master database named sp_help_revlogin and sp_hexadecimal.<\/p>\n
If you do not know about the concept of Stored Procedure, you may want to read the article “Stored Procedure On SQL Server<\/a>“.<\/p>\n
After running the above script on the source server you want to get login information, you are running sp_help_revlogin sp.<\/p>\n
This script gives you the scripts of the Login’s you want to carry in encrypted form.<\/p>\n
You can run it on the target server by copying the part of the login you want to move from the script.<\/p>\n
When you move the Logins in this way, they are copied along with the SIDs.<\/p>\n
That is not the same as creating a new login from scratch on the target with the login name and password in the source.<\/p>\n
The SID of a Login is like a fingerprint of login.<\/p>\n
The two logins created with the same name and the same password on different instances are different from each other.<\/p>\n
For example, you have a login named denemeUser on the Resource Instance.<\/p>\n
And let’s assume that this login is db_owner authority in the database named “deneme”.<\/p>\n
We transfer the “deneme” database to another instance using the backup restore method.<\/p>\n
You can find out more about this process from the article titled “Backup Restore On SQL Server<\/a>“.<\/p>\n
Instead of moving the denemeUser login using the sp_help_revlogin method, we create the same name and the same password on the target instance.<\/p>\n
After this process, we will not be able to access the\u00a0 database named “deneme” with the new login name we created on the target instance.<\/p>\n
Normally, when we authorize a login at database level with user mapping in a database, a user belonging to that login under the database is created and this user is moved automatically during backup restore.<\/p>\n
However, if you do not move the source login to the target with SID, you will not be able to access the target database.<\/p>\n
Because the SIDs of the login that you created with the same name in the target will not match the user being moved to the target with the backup method under the database.<\/p>\n
There is another way to equalize the SIDs of logins with the same name. But I do not mention this method because microsoft does not suggest this method.<\/p>\n
You can access from the link below.<\/p>\n
https:\/\/msdn.microsoft.com\/en-us\/library\/ms174378.aspx<\/a><\/p>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
  If you do not use a contained database, you must also move your logins when you move the database to another instance. You can find detailed information about the Contained Database in the article “What is Contained Database and How To Create“. You can use the script below to move the logins to another …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2332","post","type-post","status-publish","format-standard","","category-mssql"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":925,"today_views":0},"yoast_head":"\nHow To Move Logins To Another Instance(sp_help_revlogin) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Move Logins To Another Instance(sp_help_revlogin)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/08\/29\/how-to-move-logins-to-another-instancesp_help_revlogin\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Move Logins To Another Instance(sp_help_revlogin) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Move Logins To Another Instance(sp_help_revlogin)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/08\/29\/how-to-move-logins-to-another-instancesp_help_revlogin\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-29T13:47:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-24T14:55:55+00:00\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/29\/how-to-move-logins-to-another-instancesp_help_revlogin\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/29\/how-to-move-logins-to-another-instancesp_help_revlogin\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Move Logins To Another Instance(sp_help_revlogin)\",\"datePublished\":\"2018-08-29T13:47:47+00:00\",\"dateModified\":\"2018-11-24T14:55:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/29\/how-to-move-logins-to-another-instancesp_help_revlogin\/\"},\"wordCount\":534,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/08\/29\/how-to-move-logins-to-another-instancesp_help_revlogin\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/29\/how-to-move-logins-to-another-instancesp_help_revlogin\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/29\/how-to-move-logins-to-another-instancesp_help_revlogin\/\",\"name\":\"How To Move Logins To Another Instance(sp_help_revlogin) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2018-08-29T13:47:47+00:00\",\"dateModified\":\"2018-11-24T14:55:55+00:00\",\"description\":\"How To Move Logins To Another Instance(sp_help_revlogin)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/29\/how-to-move-logins-to-another-instancesp_help_revlogin\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/08\/29\/how-to-move-logins-to-another-instancesp_help_revlogin\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/29\/how-to-move-logins-to-another-instancesp_help_revlogin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Move Logins To Another Instance(sp_help_revlogin)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Move Logins To Another Instance(sp_help_revlogin) - Database Tutorials","description":"How To Move Logins To Another Instance(sp_help_revlogin)","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2018\/08\/29\/how-to-move-logins-to-another-instancesp_help_revlogin\/","og_locale":"en_US","og_type":"article","og_title":"How To Move Logins To Another Instance(sp_help_revlogin) - Database Tutorials","og_description":"How To Move Logins To Another Instance(sp_help_revlogin)","og_url":"https:\/\/dbtut.com\/index.php\/2018\/08\/29\/how-to-move-logins-to-another-instancesp_help_revlogin\/","og_site_name":"Database Tutorials","article_published_time":"2018-08-29T13:47:47+00:00","article_modified_time":"2018-11-24T14:55:55+00:00","author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/29\/how-to-move-logins-to-another-instancesp_help_revlogin\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/29\/how-to-move-logins-to-another-instancesp_help_revlogin\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Move Logins To Another Instance(sp_help_revlogin)","datePublished":"2018-08-29T13:47:47+00:00","dateModified":"2018-11-24T14:55:55+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/29\/how-to-move-logins-to-another-instancesp_help_revlogin\/"},"wordCount":534,"commentCount":2,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/08\/29\/how-to-move-logins-to-another-instancesp_help_revlogin\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/29\/how-to-move-logins-to-another-instancesp_help_revlogin\/","url":"https:\/\/dbtut.com\/index.php\/2018\/08\/29\/how-to-move-logins-to-another-instancesp_help_revlogin\/","name":"How To Move Logins To Another Instance(sp_help_revlogin) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2018-08-29T13:47:47+00:00","dateModified":"2018-11-24T14:55:55+00:00","description":"How To Move Logins To Another Instance(sp_help_revlogin)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/29\/how-to-move-logins-to-another-instancesp_help_revlogin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/08\/29\/how-to-move-logins-to-another-instancesp_help_revlogin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/29\/how-to-move-logins-to-another-instancesp_help_revlogin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Move Logins To Another Instance(sp_help_revlogin)"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/2332","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=2332"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/2332\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=2332"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=2332"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=2332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}