Create a Windows Server In Azure for TFS Migration

We would use the data migrator tool to complete the necessary steps.

After Our Talk With MS Support

This is the target machine to create for Azure devops 2022 which can intake the database without any data migration

My datatabase 2018 v3 beta 2

create a windows 1

Update the presentation that is built in canva > Use the presenter notes for scripts

create a windows 2

Search market place

create a windows 3

https://portal.azure.com/#view/Microsoft_Azure_Marketplace/MarketplaceOffersBlade/selectedMenuItemId/home

Server AMI URL >

Dev Licence > Pray for the import size

create a windows 4

Not documented

create a windows 5

https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2017?view=sql-server-ver16

Basic portal errors

create a windows 6

Hit network tab and back...

create a windows 7

Get the install media > let the system download an iso by letting the download on the internet settings of the browser

https://drive.google.com/file/d/1L5IkOF6UxH4tF9vpXJyJTQTbnKSvsVXX/view?usp=sharing

Start your install

create a windows 8

After Install Restore thedatabase

create a windows 9

Locate Backup

create a windows 10

Drink your tea while database gets restored > thanks to Chandra restoring to the 2022 server

create a windows 11

Select I have an existing database even it is 2018 the 2022 Server should be able to ingest it

create a windows 12

Issue

create a windows 13

If you install as fresh server

create a windows 14

You would end up with the configuration database

create a windows 15

create a windows 16

Now attach collection

create a windows 17

Accept and attach

create a windows 18

create a windows 19

Get the errors with the Failed to sync identity or group

create a windows 20

create a windows 21

Note : Ask the enterprise to do the Azure AD Sync from the tech team

Set up your machine for program install

Choco Install

Set-ExecutionPolicy Bypass -Scope Process -Force; [System.Net.ServicePointManager]::SecurityProtocol = [System.Net.ServicePointManager]::SecurityProtocol -bor 3072; iex ((New-Object System.Net.WebClient).DownloadString('https://community.chocolatey.org/install.ps1'))

create a windows 22

Restart the power shell and go back to the migration tool path

Time to install the migration tool ( As we have the database that is attached )

https://www.microsoft.com/en-us/download/details.aspx?id=54274

create a windows 23

Download in the Azure DevOps Server Yes Yes Yes

create a windows 24

Get the correct version

create a windows 25

Extract

create a windows 26

Open the path in power shell

cd C:\Users\rifaterdemsahin\Downloads\DataMigrationTool_AzureDevOps2022RTW_19.205.19599188\DataMigrationTool

create a windows 27

Pin paths on the box

create a windows 28

Validate the collection

create a windows 29

Get your steps in now from the proof of concept stage

create a windows 30

always record your steps

create a windows 31

Prepare and Validate

C:\Users\User\Downloads\DataMigrationTool_AzureDevOps2022RTW_19.205.19599188\DataMigrationTool> .\Migrator.exe validate /collection:http://windev2305eval/DefaultCollection/ /tenantdomainname:pexabo.onmicrosoft.com

MFA needs to turn on

create a windows 32

ReRun

create a windows 33

mmmm > password time!

create a windows 34

Features

create a windows 35

More MFA Questions

create a windows 36

create a windows 37

Now Time to Prepare

PS C:\Users\User\Downloads\DataMigrationTool_AzureDevOps2022RTW_19.205.19599188\DataMigrationTool> .\Migrator.exe prepare /collection:http://windev2305eval/DefaultCollection/ /tenantdomainname:pexabo.onmicrosoft.com /region:CUS

4 MFA > Number entry over the Microsoft authenticator

create a windows 38

Take a note of the Log Folder Created

create a windows 39

Choco install the azure storage explorer

https://community.chocolatey.org/packages/microsoftazurestorageexplorer

choco install microsoftazurestorageexplorer

create a windows 40

Pin it to the taskbar

create a windows 41

MFA

create a windows 42

Create Storage

create a windows 43

create a windows 44

create a windows 45

Check your version of the migration tool and the operating system and Azure devops server needs to lineup

create a windows 46

Check your environment to make sure

create a windows 47

Install SQL package and vscode

https://community.chocolatey.org/packages/sqlpackage

choco install sqlpackage -y

choco install vscode -y

create a windows 48

Get the path and move it to favorites

The install of sqlpackage was successful.

Software installed to 'C:\ProgramData\chocolatey\lib\sqlpackage\tools'

Also save it to notepad for future easy access

create a windows 49

Check SQL package

create a windows 50

Find your Notion notes by the power of Full Text Search ( Gray Skull (: )

create a windows 51

Create a folder for dacpacs

create a windows 52

WHEN CREATING DACPACS THE SYSTEM HAS TO BE DETACHED IN AZURE DEVOPS SERVER BUT ATTACHED IN SQL SERVER

SqlPackage.exe /sourceconnectionstring:"Data Source=localhost;Initial Catalog=AzureDevOps_DefaultCollection;Integrated Security=True" /targetFile:C:\dacpac\Tfs_DefaultCollection.dacpac /action:extract /p:ExtractAllTableData=true /p:IgnoreUserLoginMappings=true /p:IgnorePermissions=true /p:Storage=Memory

Save your script to the notepad for future reference and debug

create a windows 53

Make sure the connection string works

create a windows 54

Certificate Chain By Pass

create a windows 55

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/certificate-chain-not-trusted?tabs=ole-db-driver-19

Let it process the tables

create a windows 56

It would take the time get a tea at this time.

create a windows 57

Before Moving the dacpacs UPDATE the necessary parts

create a windows 58

Use VSCode and Open the file under the log folder

create a windows 59

Logs as top folder

create a windows 60

VSCode Open up tactic

code .

create a windows 61

Set trust

create a windows 62

Go to latest import.json

create a windows 63

4 places to update before the trigger

create a windows 64

Sas Update
dacpacfile
target organization
dryrun

First update Create Tokens( 2 weeks minimum )

dacpac level

create a windows 65

create a windows 66

Cloud server faster copy

create a windows 67

Now time to go to logs and open the vscode

Master these files before moving them to cloud

When the migration starts it is from cloud to cloud ! After you are done it is time to do the transfer much faster!

create a windows 68

Take the dacpac name from here

create a windows 69

Have it pinned and set it in the easy access

create a windows 70

Check the dacpack size

create a windows 71

Trigger Migration

cd C:\Users\rifaterdemsahin\Downloads\DataMigrationTool_AzureDevOps2022RTW_19.205.19599188\DataMigrationTool

.\Migrator.exe import /importfile:Logs\DefaultCollection\20230607_134346\import.json

Add the script to the notes on the desktop for the future reference

create a windows 72

If there is an error with the blob

create a windows 73

Make sure the folders are matching

create a windows 74

Try the access on your staging box

create a windows 75

After correct was key location

create a windows 76

create a windows 77

NOW DETACH TIME

Pin the admin console to the taskbar

Detach ( the transformation happened from 2018 to 2022 import )

create a windows 78

create a windows 79

Push your back up

create a windows 80

Pin to start the backup tool SQL management studio

create a windows 81

Also to the task bar

create a windows 82

Connect to the box and backup the collection

create a windows 83

create a windows 84

Wait it out

create a windows 85

Detach from the Administration Console

create a windows 86

create a windows 87

create a windows 88

ReTrigger

create a windows 89

create a windows 90

If the db is detached by the migratory fails restart the box to drop caches.

Give the permissions and the URL at the container level in the middle

create a windows 91

Ask azure support if stuck

create a windows 92

Trouble Shoot Guide

https://learn.microsoft.com/en-us/azure/devops/migrate/migration-troubleshooting?view=azure-devops

Looks like I need to recreate the dacpac

create a windows 93

After recreating the dacpac make sure to prepare one more time otherwise it can fail just like this

create a windows 94

Cost increase till we move on to the customer staging machine

create a windows 95

Get the importID to give it to the Azure support

create a windows 96

[Info @18:29:44.796] Import ID: 57ac4c69-b50a-4b2c-ad29-fa4af7000631

Azure Support

create a windows 97

Check SQL package version

create a windows 98

Learn where you made the error from the Azure support

create a windows 99

Learn the order

create a windows 100

Fails in the first 10 minutes

create a windows 101

Check SQL package from the command prompt

create a windows 102

Reread the error and start from scratch and share with the cohost the Azure support

create a windows 103

Recorded Steps

Turn on the box ✅
detach the collection
create a dacpac with the detached collectiondb name it v3
move to storage
attach
create a SAS key
validate
prepare
update the import json
import
report back to support with import id and the video
Delete the blob and recreate

It fails at the prototype and the Azure team with SQL team is working on it to resolve it.

https://0fa1fa7e-c21a-4ce0-b746-e298cc48024e.usrfiles.com/html/2b2e4b_d767b483cae16e027c4ea8ac7906fbf4.html

Reference

https://sonin.agency/the-4ps-innovation-model-poc-prototype-pilot-production

Contact me on Linkedin > https://www.linkedin.com/in/rifaterdemsahin/

Imported from rifaterdemsahin.com · 2024

Create a Windows Server In Azure for TFS Migration

📚 Related Reading