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.
| Author |
Topic |
|
cool_moon
Starting Member
26 Posts |
 Posted - 2004-03-23 : 19:17:43
|
| Hello there...Well i want to ask that.... is it posible to Export/Convert MS Sql server Tables/Views + Database to MySql server.....? or is there any software which can automatically convert MS Sql Server database into MySql database.I'll be REALLY GLAD if someone can please help me asap...take care...RegardsNabeel Qaisar |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-23 : 19:18:43
|
| If you have a MySQL ODBC driver, then you can use DTS.Why go from MSSQL to MySQL? It seems to me that one would be going the other way.Tara |
 |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2004-03-23 : 19:27:55
|
| As Tara said, DTS is one way, BCP out to a csv file is another way...(fastest)I am running the 4.1 alpha for windows which supports FK's and subqueries and I must say that it is a great version.. Compared to version 3.2 (which I run on FreeBSD) it is a big step.. v5 will support SP's and Views.. I recommend you download it (about 20Mb) as well as the Console Centre (roughly MySQL equivalent QA) and the Admin app... A good product that should not be dismissed easily....DavidM"The easiest way to give up marijuana is to smoke so much you forget that you smoke it." |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2004-03-23 : 21:21:36
|
It sure does Rob as well as another beauty....look at the bolded value in this quote...quote:
MySQL allows you to store some wrong date values into DATE and DATETIME columns (like 2000-02-31 or 2000-02-00). The idea is that it's not the SQL server job to validate date. If MySQL can store a date and retrieve exactly the same date, then MySQL will store the date. If the date is totally wrong (outside the server's ability to store it), then the special date value 0000-00-00 will be stored in the column.
They have marked it as a bug, but the reasoning is horrible!You can drop the parent from a FK, but the FK is still enforced on the child table!!!! ie. You cannot INSERT into the child or UPDATE the key.Check this out..create table Dates(DateKey date primary key, OtherDate date);insert into dates values ('20040231', '20040301');-1insert into dates values ('20040230', '20040301');0insert into dates values ('20040229', '20040301');1insert into dates values ('20040200', '20040301');NULLinsert into dates values ('20040201', '20040301');29select * , DateDIFF(OtherDate , DateKey) from Dates;See the bolded in-line for the result...It seems to be intepreting and calculating the differences OK...DavidM"The easiest way to give up marijuana is to smoke so much you forget that you smoke it." |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-03-23 : 21:54:18
|
quote:
They have marked it as a bug, but the reasoning is horrible!
You gravely insult the concept of reason by mentioning the MySQL documentarians and developers in the same sentence.  Yeah, it's definitely one of their trademark phrases: "It's not the responsiblity of the database to validate data or enforce data integrity." |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-03-24 : 19:40:49
|
quote:
Originally posted by robvolk
Yeah, it's definitely one of their trademark phrases: "It's not the responsiblity of the database to validate data or enforce data integrity."
Then whose responsibility to they think it is? The front-end application developer's? I think it's a good practice to have your application validate it, but if it doesn't, or misses it for some reason, I want the database to reject it too.--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
|
|
|
|
|
|
|
|
Export to MySql from MSSql