SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 06:04 PM
| ||||
| ||||
 Shared Sybase MSSQL data I need to find a way for our agency to share data from our SQL 2000 db running on W2K server with another agency's Sybase ASE 12.5 db running on Solaris 8. Ideally, both agencies would enter info into their respective dbs, which would then somehow, either automatically or through a user-activated interface, populate both systems with the most current data. I know very little about Sybase, and I'm hoping someone can point me in the right direction. Any suggestions, including whether I should be posting to a different group, would be greatly appreciated!      |
|
04-08-2008, 06:04 PM
| |||
| |||
| Re: Shared Sybase MSSQL data "clamis" <holbrowa@clanet.org> wrote in message news:1127750056.513264.242640@g14g2000cwa.googlegr oups.com... > I need to find a way for our agency to share data from our SQL 2000 db > running on W2K server with another agency's Sybase ASE 12.5 db running > on Solaris 8. > > Ideally, both agencies would enter info into their respective dbs, > which would then somehow, either automatically or through a > user-activated interface, populate both systems with the most current > data. > > I know very little about Sybase, and I'm hoping someone can point me in > the right direction. Any suggestions, including whether I should be > posting to a different group, would be greatly appreciated! > Sybase has a connectivity product called 'EnterpriseConnect' (formerly 'DirectConnect') which lets you access data in an MS-SQL server through proxy tables in ASE. More info at http://www.sybase.com/products/infor...nectdataaccess . HTH, Rob ------------------------------------------------------------- Rob Verschoor Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0 and Replication Server 12.5 / TeamSybase Author of Sybase books (order online at www.sypron.nl/shop): "Tips, Tricks & Recipes for Sybase ASE" "The Complete Sybase Replication Server Quick Reference Guide" "The Complete Sybase ASE Quick Reference Guide" mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME http://www.sypron.nl Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands ------------------------------------------------------------- |
|
04-08-2008, 06:04 PM
| |||
| |||
| Re: Shared Sybase MSSQL data Hi On the ASE Server, they could run Sybase Replication Server http://www.sybase.com/products/infor...licationserver that would replicate data from ASE to SQL Server. But, your application needs to be designed for this (things like identity columns need to be ranged etc). Regards -------------------------------- Mike Epprecht, Microsoft SQL Server MVP Zurich, Switzerland IM: mike@epprecht.net MVP Program: http://www.microsoft.com/mvp Blog: http://www.msmvps.com/epprecht/ "clamis" <holbrowa@clanet.org> wrote in message news:1127750056.513264.242640@g14g2000cwa.googlegr oups.com... >I need to find a way for our agency to share data from our SQL 2000 db > running on W2K server with another agency's Sybase ASE 12.5 db running > on Solaris 8. > > Ideally, both agencies would enter info into their respective dbs, > which would then somehow, either automatically or through a > user-activated interface, populate both systems with the most current > data. > > I know very little about Sybase, and I'm hoping someone can point me in > the right direction. Any suggestions, including whether I should be > posting to a different group, would be greatly appreciated! > |
Linear Mode
