Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - Convert from mySQL til MS SQL
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Convert from mySQL til MS SQL

 Post Reply Post Reply
Author
AllMor View Drop Down
Groupie
Groupie
Avatar

Joined: 16 April 2010
Location: Denmark
Status: Offline
Points: 70
Post Options Post Options   Thanks (0) Thanks(0)   Quote AllMor Quote  Post ReplyReply Direct Link To This Post Topic: Convert from mySQL til MS SQL
    Posted: 13 October 2021 at 12:33pm
Hi Smile

I have a forum with 2.600 members, containing 22.000 posts, in 4.500 topics.
My forum runs on a mySQL database.

Is there any way (paid or unpaid) for me to migrate from mySQL to a Microsoft SQL database?

Have a nice day

Allan
https://forum.excel-regneark.dk
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9791
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 13 October 2021 at 3:55pm
I recall doing this many years ago for someone and it was very difficult and took the best part of a couple of days to complete.

I would not have the time these days to do such a migration, so unless you want to try and do it yourself you might be stuck with MySQL.

The fields that caused the biggest issue are date/time fields and Smallint in MySQL would be a Bit data type in SQL Server.
Back to Top
AllMor View Drop Down
Groupie
Groupie
Avatar

Joined: 16 April 2010
Location: Denmark
Status: Offline
Points: 70
Post Options Post Options   Thanks (0) Thanks(0)   Quote AllMor Quote  Post ReplyReply Direct Link To This Post Posted: 14 October 2021 at 8:25am
Thank you for your answer Bruce
I think it's worth the effort - maybe In the dark winter evenings, I can find the peace to do the job. LOL

Did you use any kind of converter-tool, or did you do the job manually?
https://forum.excel-regneark.dk
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9791
Post Options Post Options   Thanks (1) Thanks(1)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 14 October 2021 at 9:30am
Yes, I used a convertor tool and then went through correcting the data types for fields that did not convert correctly. I think I used Navicat, but it was almost 10 years ago, I could be wrong.

What I would suggest is creating a new install of Web Wiz Forums SQL Server version so that it can create a database that you can use for reference. Then when you migrate your MySQL database to SQL Server you can check that the data types for the fields are correct when compared to the reference database.
Back to Top
Jamesdexter View Drop Down
Newbie
Newbie
Avatar

Joined: 25 October 2019
Location: Woodburn, OR
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote Jamesdexter Quote  Post ReplyReply Direct Link To This Post Posted: 14 January 2022 at 6:42pm
test
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.07
Copyright ©2001-2024 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2024 Web Wiz Ltd. All rights reserved.