Migrate Data from SQL Server 2019 on Windows 10 to SQL Server 2022 on Ubuntu 22.04

Published: 07 November 2023
on channel: Subhroneel Ganguly

153

Install and Migrate Data to SQL Server 2022 on Ubuntu 22.04 from SQL Server 2019 on Windows 10

01:00 MSSQL Server 2022 deb package installation on Ubuntu 22.04
02:53 MSSQL Server 2022 configuration on Ubuntu 22.04
05:13 adding tcp port on firewall on Ubuntu 22.04
06:54 MSSQL Server 2022 creating user, login and db on Ubuntu 22.04
09:54 Migrating data from MSSQL Server 2019 on Windows 10 to MSSQL Server 2022 on Ubuntu 22.04 using Microsoft Management Studio Migration Wizard
14:22 Migrating data from MSSQL Server 2019 on Windows 10 to MSSQL Server 2022 on Ubuntu 22.04 using Microsoft Management Studio using backup and restore database method

Script to create DB, user and login in MSSQL Server 2022 :
CREATE DATABASE [db_name];
CREATE LOGIN [login_name] WITH PASSWORD = [StrongPassword];
ALTER SERVER ROLE [sysadmin] ADD MEMBER [login_name];
USE [db_name];
CREATE USER [user_name] FOR LOGIN [login_name];
ALTER USER [user_name] WITH DEFAULT_SCHEMA=[dbo];
ALTER ROLE [db_owner] ADD MEMBER [user_name];
USE master;

Microsoft SQL Server All Edition 2022 for Ubuntu 22.04 download link : https://packages.microsoft.com/ubuntu...

Mocrosoft ODBC SQL driver 18 download link : https://packages.microsoft.com/ubuntu...

Microsoft Express Edition 2019 for Windows 10 download link : https://download.microsoft.com/downlo...

Microsoft SQL Server Management Studio 19.1 for Windows 10 : https://aka.ms/ssmsfullsetup

Oracle SQL Developer with JDK 11 for Windows 10 64 bit : https://download.oracle.com/otn/java/...

Oracle SQL Developer without JRE for Windows 10 64 bit :
https://download.oracle.com/otn/java/...

Source to download third party jdbc driver for Oracle SQL Developer Connection :: https://sourceforge.net/projects/jtds...

Watch video Migrate Data from SQL Server 2019 on Windows 10 to SQL Server 2022 on Ubuntu 22.04 online without registration, duration hours minute second in high quality. This video was added by user Subhroneel Ganguly 07 November 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 15 once and liked it people.

2,61