RE: Migration to mysql from MS SQL Server

2001-10-04 Thread Will French
IL PROTECTED] > Subject: Re: Migration to mysql from MS SQL Server > > > > Harpreet writes: > > > Can we create a php page that will use mssql_connect to connect > to ms sql > > server get the data and then use mysql_connect and connect to > mysql server > &g

Re: Migration to mysql from MS SQL Server

2001-10-04 Thread Carl Troein
Harpreet writes: > Can we create a php page that will use mssql_connect to connect to ms sql > server get the data and then use mysql_connect and connect to mysql server > and populate the table. > > Is this possible. Yes, but only if you don't include 8 kilobytes worth of redundant irrelevanc

RE: Migration to mysql from MS SQL Server

2001-10-04 Thread Harpreet
: Will French [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 10:00 PM To: [EMAIL PROTECTED]; Pavel Hant; [EMAIL PROTECTED] Subject: RE: Migration to mysql from MS SQL Server venu:> If you can make use of MS Access and ODBC in the middle layer in venu:> the conversion, venu:> f

RE: Migration to mysql from MS SQL Server

2001-10-03 Thread Will French
From: Venu [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 03, 2001 4:00 PM > To: [EMAIL PROTECTED]; Pavel Hant; [EMAIL PROTECTED] > Subject: RE: Migration to mysql from MS SQL Server > > > Hi !!! > > > -Original Message- > > From: Will French [mail

RE: Migration to mysql from MS SQL Server

2001-10-03 Thread Venu
Hi !!! > -Original Message- > From: Will French [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 03, 2001 12:28 PM > To: Pavel Hant; [EMAIL PROTECTED] > Subject: RE: Migration to mysql from MS SQL Server > > > I just did this with a rather large database. H

RE: Migration to mysql from MS SQL Server

2001-10-03 Thread Will French
I just did this with a rather large database. Here are the steps that I followed: 1. In MSSQL Enterprise Manager, use "generate scripts" to, well, generate your SQL scripts. (right click on any table and select All|Generate Scripts). I decided to break save the index builds until after the dat