SQL Server Performance

Sharing Tables between Instances

Discussion in 'SQL Server 2008 General DBA Questions' started by rohaandba, Feb 4, 2011.

  1. rohaandba New Member

    There is a SQL Server Instance-1....With a Database-1....haveing 6 tables
    Among which 3 of the tables have to be shared by
    Another SQL Server Instance-2.....with a Database-2

    Can anyone help me how to do the sharing of the 3 tables between 2 SQL Server instance or Servers
    rohaandba, Feb 4, 2011
    #2

  2. RamJaddu Member

    Create a linked server on second server instance points to first server database then create views on second server database pointing to first server database tables with same names.
    or if you want to copy the data across several options T-SQL scripts / SSIS Packages /replications.
    RamJaddu, Feb 4, 2011
    #3

  3. Luis Martin Moderator

    [quote user="RamJaddu"]
    Create a linked server on second server instance points to first server database then create views on second server database pointing to first server database tables with same names.
    or if you want to copy the data across several options T-SQL scripts / SSIS Packages /replications.
    [/quote]
    First part sound good to me. The question is (to Rohaand): do you want read and/or write on second server?
    Luis Martin, Feb 4, 2011
    #4

  4. rohaandba New Member

    Thank You.
    I need to do the read/write operations too
    rohaandba, Feb 10, 2011
    #5

  5. satya Moderator

    satya, Feb 11, 2011
    #6

Share This Page