|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
 Posted - 02 August 2013 : 09:09:17
|
This is always a case by case procedure and it really depends on the tools you have to do it. Probably the first questions is: is your forum a standard one or do you have customizations that required changes to the database structure?
The first step in a migration is always to create a clean table structure. If your forum has no changes to the snitz table structure, you can create the clean structure simply by running our setup.asp file against a clean MySQL database. If you have customizations, well, how you proceed depends on how the changes were added. If the changes are mod related, then you can execute the dbs files againts the same database, after creating the base tables. This may require a clean, unmodded version of the forum code.
If you have changes and they are not mod related and / or you do not have the dbs files, well, you may as well have to recreate the changes by hand. If you have MS SQL Server Management Studio, you can use it to script the table structure and change it, for example.
Once you deal with the table structure, you will have to import the SQL Server data. I confess I never migrated SQL Server to MySQL. The other way around, I have done it many times. With SQL Server 2012 (even with SQL Server 2008 R2), Management Studio can create a SQL 'dump', that is export all the data with multiple statements, usually one for each database record. In most cases, the syntax will be usable against MySQL with a few changes. If you have SSMS 2008 R2 or 2012, this can be an option.
I always import the data not to real database, but to a temporary one. Like this you can deal with errors and repeat the import process until it proceeds without issues. Once it is done, I use my favorite MySQL tool, SQLYog, to dump just the data and add it to the final, real database.
If you have a decent MySQL tool, things can be a lot easier. SQLYog can import data from several sources. With SQL Server, I use Access as a waypoint often, since SQLYog imports without issues from Access and Access imports without issues from SQL Server...
So, there are quiet a few variables. If you tell me how you are, tool wise, I can maybe provide more up to date guidance. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
