October 23, 2006 at 3:29 am
Hi,
Could any one let me know what exactly the convertion of the below code in MSSQL2000. Below code is written in SybaseSQL Anywhere.
"
PASSTHROUGH STOP
GO
PASSTHROUGH FOR SUBSCRIPTION TO DBA.Plannex_All_Specific
GO
"
Some details about above code is as:
Here is the details about PASSTHROUGH.
1. PASSTHROUGH [ ONLY ] FOR userid,. . .
2. PASSTHROUGH [ ONLY ] FOR SUBSCRIPTION
. . . TO [(creator)].publication-name [(constant)]
3. PASSTHROUGH STOP
Purpose
To start or stop passthrough mode for SQL Remote administration. Forms 1 and 2 start passthrough mode, while form 3 stops passthrough mode.
Usage : Anywhere.
Authorization : Must have DBA authority.
Side effects : None.
See also
Description
In passthrough mode, any SQL statements are executed by the database server, and are also placed into the transaction log to be sent in messages to subscribers. If the ONLY keyword is used to start passthrough mode, the statements are not executed at the server; they are sent to recipients only. The recipients of the passthrough SQL statements are either a list of user IDs (form 1) or all subscribers to a given publication.
Passthrough mode may be used to apply changes to a remote database from the consolidated database.
Example
PASSTHROUGH FOR rem_db ;
. . .
( SQL statements to be executed at the remote database )
. . .
PASSTHROUGH STOP ;
Thankx.
~ SHAM ~
October 23, 2006 at 12:11 pm
Sybase ASA and MS SQL Server replication is not the same. I have done both, recently with ASA 7, 8 and 9, and also MS SS 7, 2000 and 2005. I do not believe you will find any correlation between the two, sorry. Sybase, as a company, makes it so hard to do replication that even with their $240 an hour consultants sent to California out of Toronto Canada, you cannot solve seeming simple problems. At least with Microsoft SS everybody is doing it... the product is documented, and you can accomplish tasks without the high paid "help" (using the term loosly).
You can setup replication (snapshot, transaction or merge) in a few hours from scratch. Granted, there will be issues to overcome to get your actual DB replicated - such as adding primary keys to tables that do not have them, dealing with identity columns... and converting some datatypes that Sybase supports differently.
But my recommendation would be to setup from scratch, don't try to "convert" from Sybase ASA to MS SQL Server.
Good luck!
Thank-you,
David Russell
Any Cloud, Any Database, Oracle since 1982
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply