Mysql to Sql server database Migration using Dbforge Studio

Mysql to Sql Database Migration Using dbforge studio

Solution:
Install Dbforge Studio for Mysql...

Example:
1. Connection Mysql Server Using Dbforge Studio for Mysql.
2. Select Desire database -> Right click
3. Select Export Option.

4. Click-> ODBC -> click Next

5. Select Tables -> click Next
6. Use a connection string Option -> click Build button

7. Open Datasource Wizard.

8. click New-> Select Sql native Client option

9.Connect your Sql server(Destination Server)

10. Type the name of the file data source you want to save this connection to.

11. Select sql Datasource -> Select Sql Authentication

12. click Next-> Finish

13. Select DNS Name (Already Saved)
14. Check Test Connection

15. Change the databaseName


16. Next Screen enter sql password.



17. Ok-> Next -> Export
18. Records exported,Check Sql Server
Mysql to Sql Migration