[Bogdan Zagan]

just as a sugestion:

You can redirect the errors to MYQSL site. Capture the erorr and put there a help button that will open the authorised mysql site page.

Cheers, Bogdan

[Bogdan Zagan]

I'm glad that it helped you !

There are indeed some software that it supposed to work through a firewall, such Real Player for example. But you will get only problems runing this software this way.

The best and ellegant way is to use this Microsoft Firewall Client

Cheers, Bogdan

[Bogdan Zagan]

Because some of you asked from where can download an ISA Firewall Client Software, here are some links and hints:

download link

or Install tutorial

or search Google for firewall client SOFTWARE FOR MICROSOFT ISA SERVER 2000

Cheers, Bogdan

[Bogdan Zagan]

You may though solve this minor problem as we all do, without making any changes to the firewall.

INSTALL A FIREWALL CLIENT !

Hope this helps,

Bogdan

[Bogdan Zagan]

This behaviour is common around Microsoft Products.

When you load a table into Microsoft Access, you actually load only the beginning of the table (first 100 rows). Try to see the end of the table (click on the last record button [>*] ) and the time will be the same, or even longer.

Explanation: The Microsoft Access loads only a few records, and when you navigate between records loads another set and so on.

The same effect you could obtain with SQLYog using limit in your SQL statement, eg. limit 0,100 or limit 1000,1100. You have no advantage loading the hole table into your SQLYog program.

It is right, you have to browse into your table manualy, not automathically, as Microsoft Access (and Microsoft SQL Server Enterprise Manager) does.

[Bogdan Zagan]

Nice dilema here… but there are alot of forums that debate this aspect Windows vs. OpenSource. I guess this is not the forum nor the site for this kind of debate.

SQLYog is a free product that is growing, and when will be mature enough probably will become payed, and maybe will maintain a lite free variant. This is how is happening in the most cases. It is a normal process.

I wish luck to the development team !

[Bogdan Zagan]

No doubt.

And I would be glad to give you some advices or assistance and to try the product … from an DBA's perspective.

Another way of popularising your product would be the creation of plugins… or extensions. This way we could contribute to the development of your product 😎

Take a look at Macromedia's products (DW MX especially)

[Bogdan Zagan]

Thats the spirit !

I like your answer better than Cal's 😀

I watch close the database market share. The big pretenders are Oracle and Microsoft. But Microsoft is doing more than Oracle to make things happend easyer and faster. For now the advantage is the OS under Oracle works. But this won't be for long an argument when the comparison between OS's would resume to some hardware differences.

[Bogdan Zagan]

I will give you an answer Cal:

Let's say your DB is under heavy processing (an C program wich performs a lot of operations, such as table scans for custom index creation on the constant run).

On the other hand you have lots of http requests for Apache. Everyone knows MySQL is not so great with updates (especially when you configure it for select speed).

So you work on the developement server (24/7) and when the condition are met you syncronize data and structure with the production server.

In my case, the amount is around 10 G within an interval of 2 days. (try http://www.3dseek.com)

In other cases there could be the third level, when you need data for OLAP. No DBA would make reports on the production server. In this case you take the data from the production server into the reporting server, denormalise the structure for speed and fire the reports you need.

Hope this helps you.

Cheers !

[Bogdan Zagan]

Actually you can !

—General—

Not with SQLyog for the moment, but use Scheduled Tasks. You can find this under Programs » Accesories » System Tools

! Attention !

Here comes the fun. You only can execute an .exe program. Ask a friend that knows Visual Basic or Visual C or other program to write for you a small program with the SQL commands that you wish to perform automatically. Compile the program (not actually a program but a small set of SQL queryes and connection strings)

! Alternative !

For unix systems such FreeBSD, Linux etc. there is a program called CRON that could execute Shell or Perl Scripts. This is a much easyer alternative. Search Google for examples and you will find more that you need.

—End general—

—Your answer—

In Enterprise manager (MsSQL) open Data Transformation Services (you will find this in Tools Menu). Create the package specifying the source (MsSQL server with the correct driver) and the destination (MySQL with the correct driver – MyODBC). Save the package.

Go to the Server Management, Jobs and right click » NEW JOB. Then use the wizard for schedule, allerts etc.

—End your answer—

If I where in your management / development team I would advice you to work around this problem, Ritesh!

I use a lot Microsoft SQL Server, and the killing feature is the ease of creating jobs for database maintenance.

This feature could be easy implemented with your program… at least for UNIX servers. I cannot anticipate but I guess Windows 2003 will be a surprise for all of us !

Cheers

[Bogdan Zagan]

Well, for anybody that whants a good program with TAB completion for many scripting languages, including SQL and PL/SQL try this url: SciTE

One advice though. Try to read directions carefullly, becouse the site is written in BSD style (programmer to programmer).

You will find for Windows version an installer that is very helpfull. Also, there is another download for Windows that suites you for PHP. You can adapt the config files to work for your SQL language.

Among the features you got:

1. Syntax Colour

2. Autocompletion list with TAB selection

3. Function explanation

4. F1 help opening your CHM manual file

5. Folding (expand / contract the FOR or IF or LOOP statements)

6. … much more …

[Bogdan Zagan]

Thank you.

If is possible, I would like to test it before the official release 😎

I'm trying to get my “decision factors” the attention about open source alternatives such as FreeBSD and MySQL and I would like to see this feature well implemented 🙂

[Bogdan Zagan]

What about CTRL+BREAK ?

Will be added on a future release ?

Thank you

[Bogdan Zagan]

Hi again!

Quote:

If you mean try and open the batch in SQLyog….NO, DON'T DO IT! RUN AWAY! It's a known issue that SQLyog won't …

What can I say Cal… this is not a good attitude at all. I see that you're pretty active on this FORUM, but I think you've just rushed on this one.

Try this url :J-Write and you will find a component that can handle files that aproach the maximum size supported by your OS.

Now, if u are an enterprise developer (using Oracle, Ingres and even Microsoft SQL Server) you have to deal with such files almost every day.

Why not SQL Yog have this feature built in ?

This is a big step to Enterprise Customers, and let's be honest, the Enterprise Customers pay the bills !

Regards, Bogdan Zagan

[Author]

Posts