LutzM (1/28/2015)

---

Did you try use OPENQUERY to force the ORDER BY being performed at the MySQL side before transferring the data?

What happens if you run that query directly at the...

Someone on a MySQL forun feels confident it's not MySQl causing the problem, but rather a bottle neck in the ODBC DSN configuration ...

Thoughts on that ??

Thanks for the replies. I log on to the servers under my own account, so there is a "Reboot Now" button, but I would be the only one to see...

Is there a way to use this method, while also getting data from a MSSQL table, and inserting or updating MySQL ?? I'm guessing not.

I have another situation...

Worked perfectly. Run time from a minute down to 1 second. Thanks for explanation & solution

Great ! I think that's what I need. I will tweak it & test it .

haichells (11/10/2014)

---

Hi,

I have a 2008 database where I take Full backup on Saturday and Log backup (once in a day) for rest of the days. Here my log backup files...

Server, Instance & database settings will will depend on the environment, and once set don't change.

So, I'm not clear on what you are looking for.

I do it this way. I run a script to generate the commands so I can verify I get the right ones. I script "Results to text", then copy-paste the...

Learning the script is good, but if they are all grouped together alphabetically, you can view them on Object Explorer, then highlight them all at once and click delete.

If you...

I did something like that at the time, putting the result...

Is this a production database ? If so, is "simple" recovery acceptable from a disaster recovery perspective ?

My boss is pretty sure that the pages they were hitting do not touch the database.

I'm going to pull the trace files for that time period and take a look...

SQLRNNR (7/31/2014)

---

In both cases, you can upgrade from 2000. I might even restore the database onto the 2008R2 box and leave it in compat 80 for a few weeks...

You could export to a file with BCP, or create a SSIS package.