Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL SERVER and SYBASE
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00654102
Message ID:
00654159
Views:
15
>i have a database in sybase, unix. I want to comunicate my DB in SQL Server with the other DB in SYbase so when i make and update to some tables on the DB of SQL SERVER i can update with a store procedure or something the DB on Sybase.
>
>How can i do this?
>
>Regards,
>

Carlos,
You could create a linked server in SQL Server and use it in SPs and triggers on your SQL Server tables to update the appropriate tables in Sybase. See SQL Server Books On-line (BOL) for information on how to create a linked server.

BTW, you might have posted this in the SQL Server forum as it has nothing to do with Visual FoxPro.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform