Post reply

Synonyms

  • February 21, 2008 at 12:21 am

    #183256

    Hi all

    Is it possible to create a Synonyms in Sql server 2005 for a Oracle.

    Thank you in Advance

    Regards

    Vijay

  • February 21, 2008 at 5:53 am

    #780608

    perhaps you could expand your question a little as I'm not quite sure what you're asking, sorry.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • February 21, 2008 at 8:20 am

    #780674

    Hi,

    My scenario is i have a Sql server 2005 and oracle server. for my application i have get data from both oracle and sql server. i don't want to create two separate connection.

    For this thing i came to know that using synonyms we can create a database object of second database in the first database and using first database's connection we can access the second database. my first database is sql server and second database is oracle.

    Is it possible to create a synonym in the sql server 2005 for the oracle?

  • February 21, 2008 at 8:28 am

    #780677

    It is - just reference the linked server name. i.e.

    create synonym for SchemaName.ObjectName for OracleLinkedServerName..OracleSchemaName.OracleObjectName

    Tommy

    Follow @sqlscribe

  • February 21, 2008 at 8:30 am

    #780681

    http://www.informit.com/articles/article.aspx?p=364263

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply