Re: how to convert SQL Server 2000 database to MySQL?
Greetings What you need is a tool called SQLyog ( it has the best ODBC import utility in the market ). A very good tutorial can be found at http://www.devshed.com in the MySQL section. Do tell me how was your experience? Karam ( A satisfied user of SQLyog ) --- kumar mcmillan <[EMAIL PROTECTED]> wrote: > Hi. > First, you will be happy to know that I am migrating > a client to > PHP/MySQL from ASP/MSSQL. This is for reasons of > future preservation, > cost, security, efficiency, et cetera. The problem > is, I don't > currently have a PC and $$ to run Windows 2000 > server on. I have been > sent the MDF and LDF database files by the client... > Does someone know > of a way to convert those files to SQL without > running Windows to do > it? If not, is there an SQL-like format that SQL > Server will save as > that I can request from the client? Or is there > an application > (Windows or anything) that someone can recommend to > make this > conversion? I should point out that this is a > simple database with no > stored procedures or anything fancy. > > thanks for taking the time to read this, > Kumar > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to convert SQL Server 2000 database to MySQL?
http://hotwired.lycos.com/webmonkey/99/21/index2a_page6.html?tw=programming An example of PHP reading MySQL DB Hth, Martin - Original Message - From: "kumar mcmillan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, July 26, 2003 3:43 PM Subject: how to convert SQL Server 2000 database to MySQL? > Hi. > First, you will be happy to know that I am migrating a client to > PHP/MySQL from ASP/MSSQL. This is for reasons of future preservation, > cost, security, efficiency, et cetera. The problem is, I don't > currently have a PC and $$ to run Windows 2000 server on. I have been > sent the MDF and LDF database files by the client... Does someone know > of a way to convert those files to SQL without running Windows to do > it? If not, is there an SQL-like format that SQL Server will save as > that I can request from the client? Or is there an application > (Windows or anything) that someone can recommend to make this > conversion? I should point out that this is a simple database with no > stored procedures or anything fancy. > > thanks for taking the time to read this, > Kumar > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to convert SQL Server 2000 database to MySQL?
At 05:43 PM 7/26/2003 -0500, kumar mcmillan wrote: Hi. First, you will be happy to know that I am migrating a client to PHP/MySQL from ASP/MSSQL. This is for reasons of future preservation, cost, security, efficiency, et cetera. The problem is, I don't currently have a PC and $$ to run Windows 2000 server on. I have been sent the MDF and LDF database files by the client... Does someone know of a way to convert those files to SQL without running Windows to do it? If not, is there an SQL-like format that SQL Server will save as that I can request from the client? Or is there an application (Windows or anything) that someone can recommend to make this conversion? I should point out that this is a simple database with no stored procedures or anything fancy. thanks for taking the time to read this, Kumar Have them export the tables as CSV files. You can then easily import them into MySQL. You will also want them to generate SQL scripts for each table so that you can see the MS-SQL that it takes to create those tables - this will give you the types and names of the columns... (CSV files can be generated to give you the names on the first line, but not the type). You _should_ be able to find compatible types for each column in order to import the data into MySQL. You _may_ need to do some scripting to convert things like date/time stamps from MS-SQL to MySQL... and you will need to pay attention to differences in functinality. This should get you started. Hope this helps, _M Pete McNeil (Madscientist) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
how to convert SQL Server 2000 database to MySQL?
Hi. First, you will be happy to know that I am migrating a client to PHP/MySQL from ASP/MSSQL. This is for reasons of future preservation, cost, security, efficiency, et cetera. The problem is, I don't currently have a PC and $$ to run Windows 2000 server on. I have been sent the MDF and LDF database files by the client... Does someone know of a way to convert those files to SQL without running Windows to do it? If not, is there an SQL-like format that SQL Server will save as that I can request from the client? Or is there an application (Windows or anything) that someone can recommend to make this conversion? I should point out that this is a simple database with no stored procedures or anything fancy. thanks for taking the time to read this, Kumar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]