Results 1 to 3 of 3
  1. #1
    Join Date
    May 2008
    Posts
    1

    Unanswered: cross database operations

    Hi,
    I'm trying to get data from several databses of different kinds (Sql Server and Oracle) and from different servers - is that possible ?
    If not - is there any way to copy some data from one database to another - like tables and their content (or partial content) ?

    I tried to use "select name from <database name>..sysobjects where xtype = 'U'" but I get security error.

    thanks,
    Naama

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    Hi,

    >>I'm trying to get data from several databses of different kinds (Sql Server and Oracle) and from different servers - is that possible ?

    In MS SQL 2005, see the sp_addlinkedserver stored procedure.

  3. #3
    Join Date
    Feb 2008
    Location
    Columbus, OH
    Posts
    26
    If for whatever reason Linked Servers aren't a valid option, there's always OPENROWSET

    http://msdn.microsoft.com/en-us/library/ms190312.aspx


    Here's a nice article on using OPENQUERY and OPENROWSET with a few pointers to keep in mind.

    http://www.sqlservercentral.com/arti...aclelink/1646/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •