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
 Migrating MySql to MS SQL ?		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Webbo
Average Member

United Kingdom
982 Posts
Posted - 02 July 2008 :  17:43:24  Show Profile  Visit Webbo's Homepage
Are there any pitfalls or gains involved in migrating a MySql database to a MS SQL db?

The present db is handling an average of 827.22queries/minute and is approx 316mb in size

Also, if it's worthwhile doing so is there any software out there can can be recommended?

Thanks,

<

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 02 July 2008 :  18:21:42  Show Profile  Send ruirib a Yahoo! Message
With properly configured servers, I don't think you'd gain much. If you want to do it, the upgrade process would be the same as Access to SQL Server or Access to MySQL - Let setup.asp create the tables, use any dbs files for changes to the base tables and then import the data - Enterprise Manager / SQL Server Management Studio would be the tool to use.<

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Webbo
Average Member

United Kingdom
982 Posts
Posted - 02 July 2008 :  18:28:14  Show Profile  Visit Webbo's Homepage
Thanks for the prompt reply

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