Before convert SQL server we will require 3 software in your systems:
- MSSQL Server Or Microsoft SQL Management Studio
- XAMPP Server
- Data Loader
Let’s go…..
![Mssql to Mysql](https://utechnoworld.com/wp-content/uploads/2021/06/image_search_1622530431647-e1622530930245.jpg)
![Convert SQL server](https://utechnoworld.com/wp-content/uploads/2021/06/PicsArt_06-01-05.08.55-1024x576.jpg)
Step:- 1
I have a database that name is “Utechnoworld” and there have three tables “attendance, Employee, Persons” now I decided to convert MSSQL to MYSQL.
![](https://utechnoworld.com/wp-content/uploads/2021/05/1-1024x529.png)
Step:- 2
- Install XAMPP server
![](https://utechnoworld.com/wp-content/uploads/2021/06/2.png)
- Open Xampp Server after installation
![](https://utechnoworld.com/wp-content/uploads/2021/06/3.png)
- Start Apache and MySQL services
![](https://utechnoworld.com/wp-content/uploads/2021/06/4.png)
- Open your Browser and type http://localhost/phpmyadmin
![](https://utechnoworld.com/wp-content/uploads/2021/06/5-1024x547.png)
- Click on Databases Tab, then create a same databases which you want to convert in My case Databases name “Utechnoworld”
![](https://utechnoworld.com/wp-content/uploads/2021/06/6-1024x407.png)
- You can see created a blank databases “Utechnoworld”
![](https://utechnoworld.com/wp-content/uploads/2021/06/7-1024x409.png)
Step:- 3
Install “Data Loader” then you will open that software and click on Start New Session.
![](https://utechnoworld.com/wp-content/uploads/2021/06/8-2-1024x527.png)
- Select Source Databases Type : MS SQL Server
- Select Destination Databases Type : MySQL
- Note: Here have lot of features which you can use for future
![](https://utechnoworld.com/wp-content/uploads/2021/06/9.png)
Please fill-up you MS SQL Server Source details:
- Put your server name. { Note: Your computer Name }
- Click in Instance Name Box
- Authentication- Windows
- Click Connect
- Select Databases “Utechnoworld”
- **** you can see all the table visible on right side*****
- Select all the database and click Next
![](https://utechnoworld.com/wp-content/uploads/2021/06/10.png)
Please fill-up you My SQL Destination Server details for convert SQL server
- I have install My SQL server in Localhost so, I will put this credentials and Connect
- **** As well, you can directly put Web Server Credentials if you have ****
![](https://utechnoworld.com/wp-content/uploads/2021/06/11.png)
- Select your Target Database then Next
![](https://utechnoworld.com/wp-content/uploads/2021/06/12.png)
- Loading…….
![](https://utechnoworld.com/wp-content/uploads/2021/06/13.png)
- You can see you all table ready to convert.
![](https://utechnoworld.com/wp-content/uploads/2021/06/14.png)
- Select Run it now only and do not save
![](https://utechnoworld.com/wp-content/uploads/2021/06/15.png)
- Click to Start
![](https://utechnoworld.com/wp-content/uploads/2021/06/16.png)
- Finish { You can see databases converted }
![](https://utechnoworld.com/wp-content/uploads/2021/06/17.png)
- You can see you databases completely convert.
![](https://utechnoworld.com/wp-content/uploads/2021/06/18-1024x486.png)
1. SQL Server queries, Create a Table, Database
![SQL server](https://utechnoworld.com/wp-content/uploads/2022/04/sql-server-e1649315982500.png)
- What’s SQL Server ?
- What’s SQL server Database ?
- Types of SQL Server Data Models:
- SQL Constraints
- DDL – Data Definition Language.
- DML – Date Manipulation Language
- DCL – Data Control Language
- TCL – Transaction Control
- SQL Server Queries Example..
- Click here…
I truly appreciate this post. I have been looking all over for this! Thank goodness I found it on Bing. You have made my day! Thank you again
Thank you so much for your interest