| Author |
Topic |
|
aparnav19
Starting Member
5 Posts |
 Posted - 2008-06-04 : 17:29:58
|
| I need to configure snapshot replication (Pull) on Enterprise Edition of SQL Server 2005 (acting as Distributor, Subscriber) for Sybase server (acting as Publisher). I have the Sybase ASE client and ODBC driver installed on the Distributor. Can anyone help me add Sybase server as the publisher? Oracle publisher is allowed in Enterprise edition, but sales representative had said that we could have ODBC compliant server as the publisher. There is no option to select a different publisher other than SQL Server publisher, Oracle Publisher. If anyone knows how to do, please let me know. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-04 : 17:44:15
|
| I think if you are doing Snapshot Replication, Why don't you use linked server or SSIS to migrate to SQL Server. Replication is supported from Sybase side to SQL server, not from SQL server side to Sybase. |
 |
|
|
aparnav19
Starting Member
5 Posts |
Posted - 2008-06-04 : 23:24:50
|
| The updates from Sybase database (all its tables) has to be applied to the database on SQL server (everyday) which will be used for reporting. Since sales representative of Microsoft said that this feature is possible in Enterprise edition using Oracle Publication and ODBC driver, the company has purchased the enterprise edition of SQL Server 2005. That is the reason I am asking if anyone knows how to configure. If using SSIS, will I have to copy table by table using ADO.NET data source (ODBC driver)? That doesn't allow me to select multiple tables. I will have to write SQL query to select the table. How do I do it to copy the whole database from Sybase? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-04 : 23:46:06
|
| Well there is SQL server Migration assistant for Sybase tools available in Microsoft website. For replication purposes:http://www.sybase.com/detail?id=1024758 |
|
|
|
aparnav19
Starting Member
5 Posts |
Posted - 2008-06-05 : 01:52:25
|
| I read this white paper, but I assumed Replication Server is a Sybase product which has to be purchased again. Correct me if I am wrong. I am not strong in Sybase. Thanks for your prompt replies. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-05 : 22:37:24
|
| Sql2k5 supports Oracle publisher only for now, can't set Sybase as publisher. |
|
|
|
aparnav19
Starting Member
5 Posts |
Posted - 2008-06-06 : 16:53:44
|
| Yes, we cannot have Sybase as the publisher. Got the same answer from Microsoft Tech Support. Thanks. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-07 : 09:56:22
|
| Did you check with SQL server Migration assistant for Sybase tools in Microsoft website? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-07 : 22:27:35
|
| Not related, sql doesn't support Sybase publisher at all. |
|
|
|
|
Replication between sql server and sybase