Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MySql
 Migrate from MS-SQL to mySQL?

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!
Before posting, make sure you have read this topic!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
   

T O P I C    R E V I E W
kyodai Posted - 21 April 2011 : 08:22:56
OK seems as i need to migrate to mySQL as our Host simply does not support MS-SQL DBs larger than 1.5 GB and we have reached that.

I can clean up some poop to keep the forum alive for a few days tonight, but i really need a reliable way to migrate. Any experience/ideas? As i dont have root access to our windows hosting server i'll prolly take a full backup, import it into a Virtual machine running MS-SQL at home and use one of these 3rd party scripts/tools.


Any ideas/SUggestions/experience/caveats?
1   L A T E S T    R E P L I E S    (Newest First)
ruirib Posted - 21 April 2011 : 08:35:55
Do you have mods? If you do, do you have the dbs files?
The real issue is to get the proper table structure, which you need to do to create the tables correctly. Without mods or with dbs files, it's easy, just run the Snitz script over the MySQL database, with any dbs files to be run afterwards.

You can get the SQL Server data into Access pretty easy, through a table import using an ODBC data source for your SQL Server database. After that, you can use the recommended strategy to import from Access to MySQL. Depending on the MySQL tool you use, this can be very easy. With my paid version of SQLYog, I just import the data to a new database, automatically created by the import process and then just dump just the data to a script, to import it to the MySQL database where you used the Snitz script to create the tables.

With the right tools, it's a very straightforward process. SQLYog makes it possible, but you need a paid version. I don't really know of other MySQL tools, because I have used SQLYog for years and it does all I need.

Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000 Version 3.4.07