about sql server merge statement

I am using SQL Server 2008 Enterprise DB and using the new Merge statement (when source and target are both SQL Server 2008 DB tables), and it works well. I have another database table which is hosted in SQL Server 2005 Enterprise DB. I want to know whether Merge statement could using one table of SQL Server 2008 as source, and another tableof SQL Server 2005 as target? The two databases may not exist on the same machine.

thanks in advance, George

Answers


No - the merge statement must be able to run on the sql server where you are inserting the records, and your 2005 instance wouldn't know what to do with it.


Need Your Help

WTForms... html, autofocus?

python wtforms

Is it possible to have some of the new attribute only attributes used in HTML5, inside of WTForms?

java.security.AccessControlException: access denied ("java.lang.RuntimePermission" "modifyThreadGroup")

java hibernate google-app-engine

I am creating a web application which uses Google App Engine, Java, Hibernate, Google SQL. For development purpose, I configured my project to use MySQL. When I am trying to buildSession using hibe...