-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathReadme.txt
30 lines (22 loc) · 1.32 KB
/
Readme.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
REQUIREMENTS
PowerShell Version +5.0
MS Data Migration Assistant installed
- https://www.microsoft.com/en-us/download/confirmation.aspx?id=53595
- https://blogs.msdn.microsoft.com/datamigration/2016/10/25/data-migration-assistant-configuration-settings/
DESCRIPTION
The data migration consist of the 2 PowerShell files and 1 CSV file containen a server list
- RunMigration.ps1
- DataMigration.ps1
- myServers.csv (Sample)
Place the 2 .ps1 files in the same folder (C:\LucientDMP).
Set folder to C:\LucientDMP\
To run the solution use ISE or PS Commandline
The "exeute" file are RunMigration.ps1 it takes the following parameters
- Projectname
- SQLInstanceListLocation "CSV file"
- ResultOutputPath "C:\LucientDMP\Result\
- OutputFormat Save result as Json, CSV or All
- Target SqlServer2016, SqlServerWindows2017, SqlServerWindows2019, AzureSqlDatabase, ManagedSqlServer ,All_5
- MaxTreads "Number of simultaneous analyzing SQL Instances - reduce CPU and memory utilizing"
SAMPLE
.\RunMigration.ps1 -ProjectName "LucientMigration" -SQLInstanceListLocation "C:\temp\myServers.csv" -ResultOutputPath "C:\result\" -OutputFormat "Choose from List" -Target "Choose from List" -MaxTreads 1