I do this quite frequently. In our case, we are converting competitors data so
the process is to use Navicat (premium) to bring the data from MSSQL to MySQL
(in the same fields, etc.) and then use a program to convert it into our format
so it will run on our system. The only thing I have had
Thanks Carl.
I found a tool called Full
Converthttp://www.spectralcore.com/fullconvert/ that
did conversion (small database only) from MSSQL to MySQL. I tried to test
their Trial version and it converts completely with similar structure,
fields, etc.. Because it's trial version, some more than 5
2012/01/30 15:06 +0800, James
I am involved in a project to migrate our entire database from Microsoft
SQL to MySQL.
I would appreciate the help if anyone could share what tools will you
recommend of converting SQL database to MySQL.
If it is SQL server, maybe dumping in character form (CSV)
hi...
so i have this user in the user table in the mysql db that has all the
privileges but grant. now i need for that user to have the file
privilege so it can do into outfile. thing is i don't see that
privilege anywhere in the db table. i know that i have to do the grant
file on
Hi,
You have look at the user table which has global privileges, db is
specific to each database.
Carlos
On Mon, Jan 30, 2012 at 10:56 PM, kalin m ka...@el.net wrote:
hi...
so i have this user in the user table in the mysql db that has all the
privileges but grant. now i need for that
thanks carlos. so if i go with:
grant file on user
that wont infringe on the all other privileges the user already has,
correct?
thanks..
On 1/31/12 12:47 AM, Carlos Proal wrote:
Hi,
You have look at the user table which has global privileges, db is
specific to each database.
Correct.
Carlos
On Tue, Jan 31, 2012 at 12:03 AM, kalin m ka...@el.net wrote:
thanks carlos. so if i go with:
grant file on user
that wont infringe on the all other privileges the user already has,
correct?
thanks..
On 1/31/12 12:47 AM, Carlos Proal wrote:
Hi,
You have