Trying to migrate data from SQL 2000 to MySQL

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Trying to migrate data from SQL 2000 to MySQL

Author

Topic

noonz
Starting Member

33 Posts

Posted - 2010-06-27 : 18:21:25

I am bringing over my community server forum to vbulletin and in one of the import modules (.php) it has the following SQL query in the function to get the thread array

$sql = "SELECT ThreadID, SectionID, PostAuthor, ThreadDate, IsLocked, IsSticky, TotalViews, TotalReplies
FROM {$tableprefix}Threads
WHERE ThreadID
IN(SELECT TOP {$per_page} ThreadID
FROM (SELECT TOP {$internal} ThreadID
FROM {$tableprefix}Threads
ORDER BY ThreadID)
A ORDER BY ThreadID DESC)
ORDER BY ThreadID";

tableprefix is "cs_" since all of the tables start with "cs_" and that is declared in the config file for the importer im using

i am running the module to import the threads and it just finds 0 of 0, nothing imported

noonz
Starting Member

33 Posts

Posted - 2010-06-27 : 18:23:42

It actually just says it imported 500 records as "title", which does nothing and isn't imported as anything

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2010-06-28 : 03:56:54

I think MySQL has a tool for migrating data to/from sql server.

From http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html :

quote:
There are a wide variety of tools available to help you migrate a SQL Server or Access database to MySQL. We'll look at several different tools so you can choose the one that best suits your needs. The tools we will look at will include the following:

MSSQL2MYSQL
Microsoft DTS
SQLyog
Access Export
Text Import/Export

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources