TalkPHP - View Single Post

bmicallef · 12-02-2007, 06:07 PM

I use Ross when ever possible and there are several great tools out there for mysql database administration however, I too love Navicat.

It has 3 very important features that I use all the time.

1. Data import tools for excel, cab, XML and other formats.
I never know how or where my data is going to come from when working with a flint but Nsvicat's tools give me enough options to know I'll be able to get the job done.

2. Visual sql query builder - similar to what you find in M$ Access or OOo Base.
I'm very confident with my Sql skills, but a visual query builder is just a nice tool for prototyping a complicated query quickly. You can run the query for performance testing and switch to edit the SQL code, and back,to fine tune things at any time.

3. Data Transformation Services (DTS) with option for scheduling.
When you have multiple databases DTS is a life save, pushing and pulling datasets across servers at reqular intervals if you so desire. If you've never had to do this, when you do, you'll wish you had tools like this ...

Its one of the few prices of software I happily pay for and really enjoy using.

Brad

12-02-2007, 06:07 PM	#29 (permalink)
bmicallef The Wanderer Join Date: Nov 2007 Posts: 18 Thanks: 3	I use Ross when ever possible and there are several great tools out there for mysql database administration however, I too love Navicat. It has 3 very important features that I use all the time. 1. Data import tools for excel, cab, XML and other formats. I never know how or where my data is going to come from when working with a flint but Nsvicat's tools give me enough options to know I'll be able to get the job done. 2. Visual sql query builder - similar to what you find in M$ Access or OOo Base. I'm very confident with my Sql skills, but a visual query builder is just a nice tool for prototyping a complicated query quickly. You can run the query for performance testing and switch to edit the SQL code, and back,to fine tune things at any time. 3. Data Transformation Services (DTS) with option for scheduling. When you have multiple databases DTS is a life save, pushing and pulling datasets across servers at reqular intervals if you so desire. If you've never had to do this, when you do, you'll wish you had tools like this ... Its one of the few prices of software I happily pay for and really enjoy using. Brad