.::: Start the SQL Server Import and Export Wizard From MariaDB to MSSQL using Write a query to specify the data to transfer & compare with Open Query :::.

 

correlation with https://teguhth.blogspot.com/2025/06/start-sql-server-import-and-export.html

A. Prepare

1. MariaDB check sample query 

select * from products where product_name='laptop' or product_name='tablet';

2. create view mariadb 

create view view_produk select * from products where product_name='laptop' or product_name='tablet';

3. test if using open query

select * from openquery([MARIALOCAL],'select * from erpdb.view_produk;')
select * from openquery([MARIALOCAL],'select * from erpdb.products where product_name=''laptop'' or product_name=''tablet'';')
  

B. Import using OpenQuery 

1. select table 

--delete from teguhth..products
select * from teguhth..products

2. insert manual import MariaDB to SQL Server

SET IDENTITY_INSERT teguhth..products ON;

INSERT INTO teguhth..products (product_id, product_name, description,price,stock,created_at)
SELECT product_id, product_name, description,price,stock,created_at
FROM OPENQUERY([MARIALOCAL], 'SELECT product_id, product_name, description,price,stock,created_at FROM erpdb.view_produk');

SET IDENTITY_INSERT teguhth..products OFF

3. check result table 

select * from teguhth..products
 

C. if Using SQL import Wizard "Write a query to specify the data to transfer" 

1. using ODBC MySQL (Not MariaDB)
Dsn=mysql321;Driver={MySQL ODBC 8.0 Unicode Driver};server=10.10.10.7;uid=admin;pwd=admin;database=erpdb;port=3306

Dsn=mysql321;Driver={MySQL ODBC 8.0 Unicode Driver}

select * from erpdb.view_produk;

2. Proccess 
 

3. check Result