daivagna

# Root path
$rootPath = "master:\sitecore\content\<<Tanent name>>\<<site name>>\Home"

# Get ALL items under Home, including children
$items = Get-Item -Path $rootPath | Get-ChildItem -Recurse
echo $items
$exportData = @()

foreach ($item in $items) {
    # Collect page fields

daivagna

-----------------------------------------------------------------------------------------------------------------
INSERT INTO dbo.aspnet_Membership
SELECT [ApplicationId],
	[UserId],
	[Password],
	[PasswordFormat],
	[PasswordSalt],
	[MobilePIN],
	[Email],
	[LoweredEmail],

daivagna

/*
[aspnet_Membership]
[aspnet_Profile_CDB]
[aspnet_WebEvent_Events]
When you use insert into query, above table's columns will need to be converted to nvarchar instead of ntext for some fields
*/
/* ############# Below section only needs to be run once ###################*/
CREATE MASTER KEY ENCRYPTION BY PASSWORD='hztl@9999'
CREATE DATABASE SCOPED CREDENTIAL crossdbcred2
WITH

daivagna

<?xml version="1.0" encoding="utf-8" ?>

<!--
	GETTING STARTED WITH LEPRECHAUN
	
	1. Make a COPY of this file to store your base Leprechaun configuration. 
		- This file should go in source control.
		- It can go anywhere under your project, in some global location (like say /src)
	2. Alter the Sample.Base configuration below, in your copy, to define the model conventions of your project.
		- Where to find serialized item files