Method 1:
1. Table Structure
Use MySQL to generate the create script. Find the script to be exported and modify the Column Structure of the table created in the MySQL database according to the MySQL syntax.
2. Export table data
Use bcp on MSSQL
Method One:
1. Guide Table structure
A way to generate a create script using MySQL. Find the script that generated the export, and modify it in MySQL syntax to create the table's column structure in the MySQL database or whatever.
2
Find a good way to convert from SQLServer to Mysql database
Find a good way to convert from SQLServer to Mysql database
At the beginning of the year, I had been working on the migration of a website MSSQL2000-> MySQL5. Because different program
These days, when a user asked me about the import of the ms SQL database, I found that the MSSQL database of Godaddy cannot be released through remote control or be directly restored by backing up the Bak, you must convert it to CSV to import the
At the beginning of the year, I had been working on the migration of a website MSSQL2000-> MySQL5. Because different program systems were used, the main problem was data migration. Because the structure of the two System databases is very different,
At the beginning of the year, I had been working on the migration of a website MSSQL2000-> MySQL5. Because different program systems were used, the main problem was data migration. Because the structure of the two System databases is very different,
first, the question:
The database is Ms SQLServer2000, to import data from a table in SQLServer2000 into MySQL5, where the fields of the SQLServer2000 table are named in Simplified Chinese (it is strongly recommended not to use Chinese as the
I. Problems: The database is MS SQLServer2000. You need to import data from a table in SQLServer2000 to mysql5. the fields in the SQLServer2000 table are named in simplified Chinese (it is strongly recommended that the Field name be Chinese ). In
I. Problems:
The database is MS SQLServer2000. You need to import data from a table in SQLServer2000 to mysql5. the fields in the SQLServer2000 table are named in simplified Chinese (it is strongly recommended that the Field name be Chinese ). In
First, the question:
The database is Ms SQLServer2000, to the SQLServer2000 of a table of data into the MySQL5, where SQLServer2000 table fields in Simplified Chinese name (strongly recommended not to do in Chinese as field name). In fact, the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.