Thanks Schajee,
Did you let Access make an SQL-script to build your tables ?
You could then use such scripts in mySQL to produce a copy of the
database.
And what would you be using for the import of the data ?
cheers,
bart
> -----Oorspronkelijk bericht-----
> Van: Schajee Achmad [mailto:[EMAIL PROTECTED]]
> Verzonden: donderdag 9 augustus 2001 7:45
> Aan: Bart Goormans
> Onderwerp: Re: Migrating from MS SQLserver to MySQL
>
>
> I had an almost similar problem with conversion from
> Access to MySQL and that was easily solved by
> generating an SQL query. What access did was it
> generated an SQL query that was run on MySQL and that
> sort of imported/converted all data to MySQL. Try that
> same thing MS SQL. I'm sure there'll be someting that
> might do that.
>
> --- Bart Goormans <[EMAIL PROTECTED]> wrote:
> > Hi all,
> >
> > There's a fairly large MS SQLserver Database that my
> > client wants me to
> > convert to MySQL. Can someone advice me on how to
> > tackle this, or direct me
> > to some help.
> > There aren't any BLOBs-fields or other exotic field
> > types, mainly
> > straightforward text/integers, so I don't expect too
> > much problems on that.
> > The main issue will be its size, so an intermediate
> > tab-delimited textfile
> > might not be useable.
> >
> > (?)
> >
> > Thanks,
> >
> > Bart
> >
> >
> >
> >
> ----------------------------------------------------------
> -----------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list
> > archive)
> >
> > To request this thread, e-mail
> > <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> >
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try:
> > http://lists.mysql.com/php/unsubscribe.php
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Make international calls for as low as $.04/minute with
> Yahoo! Messenger
> http://phonecard.yahoo.com/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php