Hi all,

I am migrating a sql database to mysql , i finf datatypes like
sql_variant, flag , uniqueidentifier. Is there a substitute for all
these in mysql. please guide me & tell what should be the
corresponding datatype in mysql.. its very urgent... please reply
soon...

Thanks in advance

On 30 Jan, 07:46, agnes...@gmail.com wrote:
> Hi all,
>
> I am migrating a sql database to mysql , i finf datatypes like
> sql_variant, flag , uniqueidentifier. Is there a substitute for all
> these in mysql. please guide me & tell what should be the
> corresponding datatype in mysql.. its very urgent... please reply
> soon...
>
> Thanks in advance

Try putting
migrate mssql mysql
into a web based tool called "Google" and clicking the I'm Feeling
Lucky button. You will find details of a VB tool that will do it for
you. If instead you click the Google Search button, you will find lots
of entries dealing with this subject.

If as your post suggests you want fast answers to questions, it is
worthwhle bookmarking this google tool, you will find it very useful.

On Jan 30, 2:43 pm, Captain Paralytic <paul_laut...@yahoo.com> wrote:
> On 30 Jan, 07:46, agnes...@gmail.com wrote:
>
> > Hi all,
>
> > I am migrating a sql database to mysql , i finf datatypes like
> > sql_variant, flag , uniqueidentifier. Is there a substitute for all
> > these in mysql. please guide me & tell what should be the
> > corresponding datatype in mysql.. its very urgent... please reply
> > soon...
>
> > Thanks in advance
>
> Try putting
> migrate mssql mysql
> into a web based tool called "Google" and clicking the I'm Feeling
> Lucky button. You will find details of a VB tool that will do it for
> you. If instead you click the Google Search button, you will find lots
> of entries dealing with this subject.
>
> If as your post suggests you want fast answers to questions, it is
> worthwhle bookmarking this google tool, you will find it very useful.

Thanks for ur reply.

I installed migration toolkit mysql-gui-tools-5.0-r12-
win32.msi on windows server 2003 OS. It asked for jre so i insatlled
this jre-6u2-windows-i586-p-iftw.exe. I was able to install. In source
connection page i selected MSSQL Server, I entered hostname with port
1433(default), in username & password i gave the username & password
which i use to login into windows. It is failing to fetch the
databases & am not able to proceed to next page... Please help me
what is going wrong.. Any settings which is missing.. waiting for
reply..

Thanks in Advance.

<agnesroz@gmail.com> wrote in message
news:61259816-acd3-41ea-9e32-86aa0cc6a033@v46g2000hsv.googlegroups.com...
> On Jan 30, 2:43 pm, Captain Paralytic <paul_laut...@yahoo.com> wrote:
> > On 30 Jan, 07:46, agnes...@gmail.com wrote:
> >
> > > Hi all,
> >
> > > I am migrating a sql database to mysql , i finf datatypes like
> > > sql_variant, flag , uniqueidentifier. Is there a substitute for all
> > > these in mysql. please guide me & tell what should be the
> > > corresponding datatype in mysql.. its very urgent... please reply
> > > soon...
> >
> > > Thanks in advance
> >
> > Try putting
> > migrate mssql mysql
> > into a web based tool called "Google" and clicking the I'm Feeling
> > Lucky button. You will find details of a VB tool that will do it for
> > you. If instead you click the Google Search button, you will find lots
> > of entries dealing with this subject.
> >
> > If as your post suggests you want fast answers to questions, it is
> > worthwhle bookmarking this google tool, you will find it very useful.
>
> Thanks for ur reply.
>
> I installed migration toolkit mysql-gui-tools-5.0-r12-
> win32.msi on windows server 2003 OS. It asked for jre so i insatlled
> this jre-6u2-windows-i586-p-iftw.exe. I was able to install. In source
> connection page i selected MSSQL Server, I entered hostname with port
> 1433(default), in username & password i gave the username & password
> which i use to login into windows. It is failing to fetch the

What error message? Try supplying us with as much info as you can so
we can actually help you.

> databases & am not able to proceed to next page... Please help me
> what is going wrong.. Any settings which is missing.. waiting for
> reply..

Is your MS SQL Server set up to use "SQL Authentication" or
"Windows Authentication"? If it's SQL authentication, entering your
Windows username/password ain't gonna help, you need to enter
a proper SQL Server user and password.



--
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com