473,396 Members | 1,992 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

migrated from sqlserver2005 to mysql

232 100+
kindly help me to provide important link as i migrated from sqlserver2005 to mysql
sqlserver offers many facilities such as
easy importexport from sqlserver to any formate access excel etc
copy paste data to database
query designer to design query easily
but i can not to any of the works in mysql
Jul 13 '09 #1
3 1893
wizardry
201 100+
try this out at: www.mysql.com/downloads

they have a migration tool their for the conversion.

hope this helps.

theo
Jul 22 '09 #2
Canabeez
126 100+
Can't you dump the database from sqlserver2005 into *.sql file and then import it into mysql...?
Jul 23 '09 #3
wizardry
201 100+
i dont suggest it its to differant formats. the migration tool for sql to mysql takes procedures, functions, modules, schemas, etc... buts them in mysql format for the migration.

its like going from a windows platform to linux platform its not going to happen with out some sort of migration process.

i suggest using the tool so that you don't destroy your sys or system hive in mysql.

hope this helps.

theo werntz ii
Jul 23 '09 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Robert Franks | last post by:
Recently migrated our site to new hosts (still with linux), and am now finding that it is not picking up client cookies. The domain name is the same and the name, value and expiry date of the...
0
by: Jean-Marc Blaise | last post by:
Dear all, I would like to signal an inconvenience with the db2imigr, if root's environment points to a DB2 instance (Aix). We did a /usr/opt/db2_08_01/db2ckmig .... worked ok saying db(s) can...
2
by: Mark Olbert | last post by:
Why does the following simple query against an SqlServer2005 table in an ASPNET2 website returning less than 10 rows: SELECT link_text, idnum, ts FROM bd_content WHERE parent_id = 0 AND idnum <> 1...
2
by: Vinayagamurthy | last post by:
If it is possiable to send an SMS from SQLServer2005 to MobilePhone using any extended stored Procedures. Otherwise we can able to create any Stored Procedures for sending sms.
2
by: red_valsen | last post by:
I have a default installation of SQLServer2000 on a host running Win2003. I want to install SQLServer2005 on the same machine, but preserve the original SQLServer2000 installation. How do I do...
4
by: Mark Olbert | last post by:
I'm looking for help in getting the Transfer Sql Server Objects task to work. The goal is to transfer the tables, views, sprocs, udfs from a SqlServer 2000 database to a Sql Server 2005 database. ...
0
by: Gops | last post by:
I've find out few XML Node differences in the Migrated word 2007 document and Native Word documnet 2007 Open XML format. For Example, In Migrated word 2007 <w:p> <w:pPr> ...
1
by: yasinirshad | last post by:
HI, Can anyone tel me How to copy data from a table in one database to a table in another database using sqlserver2005. Thanks in advance.
0
by: zappbrannigan | last post by:
I am using a MSBDC and have some textfields and checkboxes bound to it. When i changed the database from access to mySQL the textfields still work fine but the checkboxes dont react. If i switch it...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.