Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 Replicating using ODBC Connection

Author  Topic 

edojan
Starting Member

4 Posts

Posted - 2007-05-07 : 14:08:03
Hi

I have EE 05 installed and need to replicated tables from an odbc connection. How would i go about doing this? I cant find a way to like import tables that i need from the odbc connection.

Thanks!

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-08 : 10:39:16
From another sql server? Only sql server or Oracle can be publisher.
Go to Top of Page

edojan
Starting Member

4 Posts

Posted - 2007-05-08 : 10:54:48
Its an oracle server but i only have odbc rights to the server. Its read only rights to tables i want to copy. How would i go about doing this?

Thanks!
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-09 : 11:23:06
Use SSIS package instead of replication.
Go to Top of Page
   

- Advertisement -