Thanks. You won't be able to browse your complete MySQL object hierarchy through the SSMS Linked Server node for the reason I mentioned in my previous post about them not...

Try this:

-- The CTE returns the cat hierarchy:

-- one row for each ancestor-descendant relationship

-- (including the self-relationship for each category)

WITH CTE

...

What does this return when executed on your SQL Server?

EXEC('SHOW VARIABLES LIKE "%version%";') AT [MYSQL];

Visual Studio 2010 has built-in Data and Schema Compare tools:

Data: http://msdn.microsoft.com/en-us/library/aa833428.aspx

Schema: http://msdn.microsoft.com/en-us/library/aa833435.aspx

mariann harper (5/17/2011)

---

I followed the steps in this article and successfully got a Linked Server on SSMS.

http://www.ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/

The database is there, but no tables are visible. Aren't I supposed to...

ooops...

mister.magoo (5/16/2011)

---

Hey opc.three,

I wasn't intentionally saying it was an easy way to bcp out, although yes that would be possible - but as you quite rightly say, that would involve...

colin.Leversuch-Roberts (5/16/2011)

---

yup I agree with you opc.three. You can't just declare replication will solve this that and the other. when databases/tables are large making changes or re-initialising the...

mister.magoo (5/16/2011)

---

I actually use SQL Agent jobs dynamically as a method of executing background tasks from a web application - where the...

While "bcp out" is possible, it is not directly usable from within T-SQL. SQL Agent jobs and xp_cmdshell do not count because those are still a...

That is definitely a good thing...

Syed Jahanzaib Bin hassan (5/13/2011)

---

Depending (there is that word again) on the volume of data changes a setup involving transactional replication can utilize infinitely more network and system resources than...

Yes, there is a relationship. If you are comparing Unicode values to Non-Unicode values the Non-Unicode values undergo what's called an "Implicit Data Type Conversion" (IDTC). An IDTC can negate...

Syed Jahanzaib Bin hassan (5/13/2011)

---

If you can use Replication then go to this because linked server have performance issue always because network will involve and you will fetch whole data...

DerbyNeal (5/13/2011)

---

Thanks for the replies

I realise that the code in my original posting needed double quotes

"\\ServerName\AX\WT A to B\Mileage.Bat"

I'm not sure whether the '/c' should be within the double...