Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MySql
 Convert from MySQL to MS SQL Server		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

digitaldi
Starting Member

7 Posts
Posted - 19 February 2008 :  17:27:28  Show Profile  Visit digitaldi's Homepage
Our hosting provider wants to retire his MySQL server and convert our SNITZ forum data from MySQL to SQL Server. Is there a tool or procedure that can do this?

We run:
Windows Server 2003
MySQL database
SNITZ Forums Copywrite 2000-2002. We plan to upgrade to the latest version.
Diane
Page Forward Design
www.pageforwarddesign.com

phy1729
Average Member

USA
589 Posts
Posted - 19 February 2008 :  17:31:22  Show Profile
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=66091&SearchTerms=MySQL,MSSQL
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=61512&SearchTerms=MySQL,MSSQL
Is what I found with a quick search there are probably more topics.
Edited by - phy1729 on 19 February 2008 17:31:38
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 19 February 2008 :  17:52:24  Show Profile  Send ruirib a Yahoo! Message
There is no tool, but you could try a procedure for that. I would upgrade to the latest version, before anything else.

Then you will need to let setup.asp create the forum tables in the SQL Server DB. Once the tables are created, you will need to import the data. I have never done that conversion and several paths are possible: MySQL -> to SQL Server via ODBC (Enterprise Manager Or SQL Server Management Studio). I'd probably try that first and check how it would go. The transfer would need to be done preserving identity fields values, not sure whether that is possible directly, really.

Maybe someone else has some experiencing on that specific path. It can be done, I'm sure, but some finetuning and experimentation may be needed.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000 Version 3.4.07