Hi Josh, are you using a file, system, or user DSN? And how are you attempting to connect to MySQL from SQL Server?

Thanks

Gaz

Old thread I know, but did you ever look into Database Snapshots?

http://msdn.microsoft.com/en-us/library/ms190677(v=sql.105).aspx

http://msdn.microsoft.com/en-us/library/ms175876(v=sql.105).aspx

Is doing tasks in serial much of a problem here? Backups are only usually limited by disk throughput.

If the servers have the same name, just overwrite the master & msdb database files on the new server with the files from the old server when they're both shut...

Does the test connection work when creating the linked server?

Note you won't be able to connect the query window directly to the MySQL instance, you need to reference it from...

andrew gothard (4/9/2014)

---

Gazareth (4/9/2014)

---

Assuming it's 4 octocore processors, take out 2 of them.

Edit: Sorry, that's a bit abrupt but it's the quickest way I can think of 🙂

Alternatively create a...

Ah, was looking forward to using

RIGHT ANGLE JOIN

PERPENDICULAR JOIN

🙂

Assuming it's 4 octocore processors, take out 2 of them.

Edit: Sorry, that's a bit abrupt but it's the quickest way I can think of 🙂

Alternatively create a VM on the...

That error looks like it's trying to use SQL Native Client to connect, which is the wrong provider.

What value are you supplying for the @provider parameter when creating the linked...

No problem, good to hear it's sorted 🙂

Yep, although at least one of them will need to be a named instance rather than a default one.

I wouldn't have thought the installer would allow you to proceed if...

Hi Wendy,

If they're referenced in the same sql, then:

WITH CTE_1

AS (),

CTE_2

AS()

SELECT ...

FROM CTE_1... CTE_2

If not:

WITH CTE_1 AS ()

SELECT ... FROM CTE_1;

WITH CTE_2 AS ()

SELECT ... FROM CTE_2;

This whole ;WITH thing...

Nice QOTD Craig, one of the best we've had for a while I think.

rodjkidd (3/3/2014)

---

Good point keep meaning to visit there. Failed miserably when I lived in the area :pinch:

Maybe I'll go on...

Lichfield & its cathedral are about 30 minutes eastwards.