[研究] 把一台 SQL Server 2019 的 AspNetUsers 中幾個帳號搬到另一台

[研究] 把一台 SQL Server 2019 的 AspNetUsers 中幾個帳號搬到另一台

2021-01-21

把 AspNetUsers 整個資料表匯出，找到要搬的幾個帳號。

裁剪中要的部分，拿到另一台 SQL Server 2019 上執行。

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO INSERT [dbo].[AspNetUsers] ([Id], [Email], [EmailConfirmed], [PasswordHash], [SecurityStamp], [PhoneNumber], [PhoneNumberConfirmed], [TwoFactorEnabled], [LockoutEndDateUtc], [LockoutEnabled], [AccessFailedCount], [UserName]) VALUES (N'aa9a4f46-7103-414a-9b50-06fb2170cad7', N'lu@nccst.nat.gov.tw', 0, N'AFU/USHZeUKbTtDOgUY/U5rav7L6LgfDacI65yMwLfNUtJJq9Faw29wfA0LxlXL2iw==', N'c3fa22d3-2da4-4715-baba-8e404c8ec06f', NULL, 0, 0, NULL, 0, 0, N'User12345A1') INSERT [dbo].[AspNetUsers] ([Id], [Email], [EmailConfirmed], [PasswordHash], [SecurityStamp], [PhoneNumber], [PhoneNumberConfirmed], [TwoFactorEnabled], [LockoutEndDateUtc], [LockoutEnabled], [AccessFailedCount], [UserName]) VALUES (N'db7b925c-99a3-4d5e-bcb5-8ad831a427ec', N'lu@nccst.nat.gov.tw', 0, N'ANIbUl/y7oTyz3pzNJRskjsFA0iHGvYzi/PCyv1+8duwqCPD8/CoATMCNGMOdOI/Zw==', N'18c73ece-7c9f-46d0-9f5d-0696618b2559', NULL, 0, 0, NULL, 0, 0, N'User12345B1') INSERT [dbo].[AspNetUsers] ([Id], [Email], [EmailConfirmed], [PasswordHash], [SecurityStamp], [PhoneNumber], [PhoneNumberConfirmed], [TwoFactorEnabled], [LockoutEndDateUtc], [LockoutEnabled], [AccessFailedCount], [UserName]) VALUES (N'e6bb099c-3dbf-4070-a030-1cfaa1bcf85c', N'lu@nccst.nat.gov.tw', 0, N'AFBOTt9vIgbvVtG3b6QojQFEkG2egZafW+WSsMF3TrV5/Ol+A/IgyJN0xRybbx7jAQ==', N'2107688e-2942-40d3-b0dc-d405b612e03c', NULL, 0, 0, NULL, 0, 0, N'User12345C1') INSERT [dbo].[AspNetUsers] ([Id], [Email], [EmailConfirmed], [PasswordHash], [SecurityStamp], [PhoneNumber], [PhoneNumberConfirmed], [TwoFactorEnabled], [LockoutEndDateUtc], [LockoutEnabled], [AccessFailedCount], [UserName]) VALUES (N'374dfdd7-a2e2-4f91-91bc-b7c14fe7d75b', N'lu@nccst.nat.gov.tw', 0, N'ALa3Y+HKoaenBHYP4Zlo/Sltji/9NQFL/B1WfzNyOBP7KwjbbMsS1t6392CvfPPZ7w==', N'00d96324-d0d5-4e2a-99e6-c3f95e7ab128', NULL, 0, 0, NULL, 0, 0, N'User12345D1') INSERT [dbo].[AspNetUsers] ([Id], [Email], [EmailConfirmed], [PasswordHash], [SecurityStamp], [PhoneNumber], [PhoneNumberConfirmed], [TwoFactorEnabled], [LockoutEndDateUtc], [LockoutEnabled], [AccessFailedCount], [UserName]) VALUES (N'7f77e138-61d1-4a4f-a53d-f77ce3eaf7f3', N'lu@nccst.nat.gov.tw', 0, N'AFFt84RqsHU8rStFiO6JCY9VEcQ9GyoIj6IW8lSciRSAyPGfgMaow1/v+PeUsuRmBA==', N'ba79259d-9ad6-419b-bec9-b0c54af0e37e', NULL, 0, 0, NULL, 0, 0, N'User12345E1') INSERT [dbo].[AspNetUsers] ([Id], [Email], [EmailConfirmed], [PasswordHash], [SecurityStamp], [PhoneNumber], [PhoneNumberConfirmed], [TwoFactorEnabled], [LockoutEndDateUtc], [LockoutEnabled], [AccessFailedCount], [UserName]) VALUES (N'3fed732f-0140-4fe4-ad29-120d2d59ef23', N'lu@nccst.nat.gov.tw', 0, N'AO1GCo+D5sDLBKFBsLDWzvbept7Vo+rM9TMcq4Diqg0aOBJpLRxluwbK2hSHRWcQoA==', N'1dad7794-1dd6-4762-a979-58abf7bb6776', NULL, 0, 0, NULL, 0, 0, N'User12345A2') INSERT [dbo].[AspNetUsers] ([Id], [Email], [EmailConfirmed], [PasswordHash], [SecurityStamp], [PhoneNumber], [PhoneNumberConfirmed], [TwoFactorEnabled], [LockoutEndDateUtc], [LockoutEnabled], [AccessFailedCount], [UserName]) VALUES (N'9e3f4a10-7c58-4e10-a1a6-b2f23a897327', N'lu@nccst.nat.gov.tw', 0, N'AIAyf0VzNX31g/n962nVgFhQp36ZUy5ekNZZ/A6Zx3cmVgENnGvOdYKbiYtwwRJYgQ==', N'9640f14e-c0e9-4b44-9ee8-827e4742640a', NULL, 0, 0, NULL, 0, 0, N'User12345B2') INSERT [dbo].[AspNetUsers] ([Id], [Email], [EmailConfirmed], [PasswordHash], [SecurityStamp], [PhoneNumber], [PhoneNumberConfirmed], [TwoFactorEnabled], [LockoutEndDateUtc], [LockoutEnabled], [AccessFailedCount], [UserName]) VALUES (N'07c9b5dc-a525-482b-a824-13985e93c2df', N'lu@nccst.nat.gov.tw', 0, N'ANRWRk7pS1f6nzu8pfQzAW2zjl6vVmHnCHyQ15JKt1Cln8hx/R4LrlZuSuP9gjQZ1g==', N'f7f2dc23-d3b1-4f19-aeaf-9372b17eb85f', NULL, 0, 0, NULL, 0, 0, N'User12345C2') INSERT [dbo].[AspNetUsers] ([Id], [Email], [EmailConfirmed], [PasswordHash], [SecurityStamp], [PhoneNumber], [PhoneNumberConfirmed], [TwoFactorEnabled], [LockoutEndDateUtc], [LockoutEnabled], [AccessFailedCount], [UserName]) VALUES (N'3846b3f9-2fb0-4012-96c9-ff1e63f7628c', N'lu@nccst.nat.gov.tw', 0, N'AO2TarWFWKtWK1is0yLjcoXD/cGawvVgOZuIqqcH2TG+yt2lQSut7AqfBVBe4HrYRg==', N'560c47a2-fd2d-4b3e-8fe9-1d23bcdb1291', NULL, 0, 0, NULL, 0, 0, N'User12345D2') INSERT [dbo].[AspNetUsers] ([Id], [Email], [EmailConfirmed], [PasswordHash], [SecurityStamp], [PhoneNumber], [PhoneNumberConfirmed], [TwoFactorEnabled], [LockoutEndDateUtc], [LockoutEnabled], [AccessFailedCount], [UserName]) VALUES (N'0ed14a3a-303e-4c15-a2a9-c058693de263', N'lu@nccst.nat.gov.tw', 0, N'AFGZAAcCNr3gJ7tVIEUdH4lqOIm/BVS99KEsUSxFDrbwysH/1E+rNbOBjVCbNJJBdw==', N'f13310a4-6022-4bda-bd2e-fa2411ca3e60', NULL, 0, 0, NULL, 0, 0, N'User12345E2') GO

(完)