|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
 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 3.4 Readme | Like the support? Support Snitz too |
 |
|
Migrate from MS-SQL to mySQL?
