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. |
|
|