There is a KB article titled "Migrate local group memberships between directories" (https://confluence.atlassian.com/jirakb/migrate-local-group-memberships-between-directories-289277867.html) and it gives the MySQL query to output the needed CSV file for migrating groups between directories (step 1). Is anyone able to translate this MySQL into SQL that can be used on Microsoft SQL Server? Or does anyone know how the CSV should be formatted so I can populate it manually? Thanks!
<span>SELECT</span> cu<span>.</span>lower_user_name<span>,</span> cg<span>.</span>lower_group_name
<span>FROM</span> cwd_user cu
<span>JOIN</span> cwd_membership cm <span>ON</span> cu<span>.</span>id<span>=</span>cm<span>.</span>child_id
<span>JOIN</span> cwd_group cg <span>ON</span> cm<span>.</span>parent_id<span>=</span>cg<span>.</span>id
<span>WHERE</span> cu<span>.</span>directory_id<span>=</span><span><</span>souce_directory_id<span>></span> <span>AND</span> cg<span>.</span>directory_id<span>=</span><span><</span>souce_directory_id<span>></span>
<span>INTO</span> <span>OUTFILE</span> <span>'/tmp/outfile.csv'</span>
<span>FIELDS</span> <span>TERMINATED BY</span> <span>','</span>
<span>ENCLOSED BY</span> <span>''</span>
<span>LINES</span> <span>TERMINATED BY</span> <span>'\n'</span><span>;</span>
