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: MS SQL Server
 Convert MySQL to MSSQL		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

ztrek7
Starting Member

3 Posts
Posted - 14 December 2007 :  10:41:18  Show Profile
I have a very basic snitz forum, no mods, just the forum that I setup with mysql. I now want to convert it to mssql as i dont have direct access to the server to install the mysql odbc drivers.

I want to mesh the forum and website logins and connecting via mssql seems the easiest method.

I searched the forums and google and only found mssql --> mysql not the other way around.

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 14 December 2007 :  11:03:29  Show Profile  Send ruirib a Yahoo! Message
Never tried that, so can't speak from experience, but the general advice would be the same:

1. Let setup.asp run on a clean SQL Server DB to have the tables created properly.
2. Use SQL Server DTS or the Import Feature in SQL Server 2005 to import the data from the MySQL DB to the SQL Server DB. This will mean that you will need to create an ODBC data source for the MySQL DB and import from it. You will need to try to ensure that identity insert is enabled for each data table.


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.16 seconds. Powered By: Snitz Forums 2000 Version 3.4.07