Is additional logging available for SQL Processing Wizard in Quest Migration Manager for AD?
N/A
Yes - the SQL processing Wizard logs to the database itself.
It creates two tables in the "Master" database:
Aelita_accounts - this table lists the accounts being updated, the source and target SIDs, etc
Aelita_log - this table contains the detailed log of the tool's activity.
As an example, below is the contents of the aelita_log table from a test lab:
1 4000 Migrating account [CHILD1\Test1] to [CHILD10\Test1]
2 4001 Migrating login
3 4002 Checking target login
4 4003 Target login not exists, creating new
5 4003 Setting default database and language
6 4002 Processing server roles
7 4002 Preparing server permissions
8 4002 Changing objects ownership
9 4002 Processing server permissions
10 4003 Processing direct permissions
11 4004 Processing permission: grant CONNECT SQL to [CHILD1\Test1] as [sa]
12 4005 Direct permission
13 4005 Source has GRANT and target doesn't have permission
14 4005 Executing grant CONNECT SQL to [CHILD10\Test1] as [sa]
15 4005 Executing revoke CONNECT SQL to [CHILD1\Test1] cascade as [sa]
16 4003 Processing owner grantor permissions
17 4002 Removing old login in replace mode
18 4003 Dropping old login
19 4001 Migrating database users
20 4002 Processing database [master]
21 4002 User not found in this database
22 4002 Processing database [model]
23 4002 User not found in this database
24 4002 Processing database [msdb]
25 4002 User not found in this database
26 4002 Processing database [QMM64]
27 4002 User not found in this database
28 4002 Processing database [tempdb]
29 4002 User not found in this database
30 4002 Processing database [Test]
31 4002 User not found in this database
32 4002 Database enumeration stopped, fetch status = -1
33 4000 Migrating account [CHILD1\Test10] to [CHILD10\Test10]
34 4001 Migrating login
35 4002 Checking target login
36 4003 Target login not exists, creating new
37 4003 Setting default database and language
38 4002 Processing server roles
39 4002 Preparing server permissions
40 4002 Changing objects ownership
41 4002 Processing server permissions
42 4003 Processing direct permissions
43 4004 Processing permission: grant CONNECT SQL to [CHILD1\Test10] as [sa]
44 4005 Direct permission
45 4005 Source has GRANT and target doesn't have permission
46 4005 Executing grant CONNECT SQL to [CHILD10\Test10] as [sa]
47 4005 Executing revoke CONNECT SQL to [CHILD1\Test10] cascade as [sa]
48 4003 Processing owner grantor permissions
49 4002 Removing old login in replace mode
50 4003 Dropping old login
51 4001 Migrating database users
52 4002 Processing database [master]
53 4002 User not found in this database
54 4002 Processing database [model]
55 4002 User not found in this database
56 4002 Processing database [msdb]
57 4002 User not found in this database
58 4002 Processing database [QMM64]
59 4002 User not found in this database
60 4002 Processing database [tempdb]
61 4002 User not found in this database
62 4002 Processing database [Test]
63 4002 User not found in this database
64 4002 Database enumeration stopped, fetch status = -1
65 4000 Migrating account [CHILD1\Test11] to [CHILD10\Test11]
66 4001 Migrating login
67 4002 Checking target login
68 4003 Target login not exists, creating new
69 4003 Setting default database and language
70 4002 Processing server roles
71 4002 Preparing server permissions
72 4002 Changing objects ownership
73 4002 Processing server permissions
74 4003 Processing direct permissions
75 4004 Processing permission: grant CONNECT SQL to [CHILD1\Test11] as [sa]
76 4005 Direct permission
77 4005 Source has GRANT and target doesn't have permission
78 4005 Executing grant CONNECT SQL to [CHILD10\Test11] as [sa]
79 4005 Executing revoke CONNECT SQL to [CHILD1\Test11] cascade as [sa]
80 4003 Processing owner grantor permissions
81 4002 Removing old login in replace mode
82 4003 Dropping old login
83 4001 Migrating database users
84 4002 Processing database [master]
85 4002 User not found in this database
86 4002 Processing database [model]
87 4002 User not found in this database
88 4002 Processing database [msdb]
89 4002 User not found in this database
90 4002 Processing database [QMM64]
91 4002 User not found in this database
92 4002 Processing database [tempdb]
93 4002 User not found in this database
94 4002 Processing database [Test]
95 4003 Checking target user
96 4004 Target user not found
97 4004 Adding target user
98 4003 Processing aliases
99 4003 Preparing roles
100 4003 Processing database roles
101 4004 Processing role: db_backupoperator
102 4004 Processing role: db_datareader
103 4003 Preparing database permissions
104 4003 Processing object ownership
105 4004 Processing remote service bindings
106 4004 Processing principals
107 4004 Changing authorization on SCHEMA::[db_backupoperator] to [CHILD10\Test11]
108 4003 Processing database permissions
109 4004 Processing direct permissions
110 4004 Processing permission: grant CONNECT to [CHILD1\Test11] as [dbo]
111 4005 Direct permission
112 4005 Source has GRANT and target doesn't have permission
113 4005 Executing grant CONNECT to [CHILD10\Test11] as [dbo]
114 4005 Executing revoke CONNECT to [CHILD1\Test11] cascade as [dbo]
115 4003 Processing owner grantor permissions
116 4003 Processing diagrams
117 4003 Removing old user [CHILD1\Test11]
118 4004 Droping old user
119 4002 Database enumeration stopped, fetch status = -1
This log was useful in a case where SQLPW was only updating some of the permissions, but not all of them. It was determined that the process was ending halfway through the job, because the last line:
119 4002 Database enumeration stopped, fetch status = -1
was not present.
