Ok. Now that I got NorthWind into my MySQL 5.0.9 database and also am running M$ SQL database server at where I work, this might be a good opportunity for me to learn how to mirgate from M$ SQL database to MySQL using Northwind and to see the difference between them. Is there anything that I should pay close attention to, in order to make the most smooth mirgation? When I migrated several databases from M$ SQL to MySQL, some dates was flushed to 0 values.
On 8/4/05, Enrique Sanchez Vela <[EMAIL PROTECTED]> wrote: > > > I ran a quick search on google regarding the NothWind > Database or schema, but I did not run across anything > that would explain what it is and what it is used for, > however, it seems to be a pretty useful and known one. > > I would appeciate insight on this. > > thanks > esv. > > ps. I think it would be more appropiate to reply > privately to me, since this does not seem to be > particulary related to MySQL. > > thanks again. > > --- "J. David Boyd" <[EMAIL PROTECTED]> wrote: > > > Peter Brawley <[EMAIL PROTECTED]> writes: > > > > > Scott, > > > > > >>Is there any database file similiar to M$'s > > Northwind that I can use to play > > >>with? It would be nice if there is one inside > > MySQL by default for newbies > > >>to start out with. > > > > > > For our chapters on Connector/ODBC and dotNet, > > Arthur & I wrote scripts to > > > create MySQL versions of the NW schema ... > > > > > > http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1_appe.html > > (InnoDB) > > > and > > > http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1_appe.html#11-2 > > > (MyISAM). If you like, I'll email you the SQL > > script for populating the > > > tables. > > > > > > PB > > > > > > > I would like to see these scripts as well. Can you > > please post them > > somewhere, or mail them to me as well? > > > > Dave > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > Enrique Sanchez Vela > email: [EMAIL PROTECTED] > > ----------------------------------------------------------------------------- > It's often easier to fight for one's || We live in the outer space > principles than to live up to them || Rev. Kay Greenleaf > Adlai Stevenson || > > > > ____________________________________________________ > Start your day with Yahoo! - make it your home page > http://www.yahoo.com/r/hs > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Power to people, Linux is here.
