Is it possible to connect to the H2 database from SQL server database

[gabjos]

Hi I have a client that wants to connect or pull data via a connection
from their SQL server database to their H2 database. Is that possible?
If so how would I do this?

[Dario Fassi]

Hi,
Driven from MsSQL to H2 it's possible but not so simple, you must use a DTS or Linked Servers (http://technet.microsoft.com/en-us/library/cc917710.aspx).
It's far more simple the reverse other way from H2 use MsSql data, using H2 linked tables in something like:

CREATE LINKED TABLE IF NOT EXISTS MYLINKEDTABLE('com.microsoft.sqlserver.jdbc.SQLServerDriver', 'jdbc:sqlserver://hostname:1433', 'username', 'userpasswd', 'REMOTE_TABLE_NAME') READONLY;
INSERT INTO SOME_LOCAL_H2_TABLE ( select * from MYLINKEDTABLE );

Sql server's jdbc driver must to be in the classpath of H2.

regards,
Dario

El 20/08/10 18:08, gabjos escribió:

[gabjos]

What should I select for the provider name?

> > If so how would I do this?- Hide quoted text -
>
> - Show quoted text -