Post reply

Replication from SQL 2000 to SQL 2005 database

  • August 9, 2011 at 1:35 pm

    #255135

    Hi,

    I'm a SQL Server newbie and have a requirement where replication needs to be done from SQL Server 2000 to a SQL Server 2005. In addition, the database @ the destination server (SQL 2005) is encrypted. Is replication possible in this scenario?

    Any help to point me in the right direction is well appreciated.

    Thanks,

    -Sekhar

  • August 10, 2011 at 12:46 am

    #1366397

    Replication from SQL Server 2000 to SQL Server 2005 is possible.

    But I am not sure about the encryption part.

    What kind of encryption is implemented?

  • August 10, 2011 at 6:50 am

    #1366516

    Hi Suresh,

    The database at the destination is on SQL Server 2005 and it uses SQL encryption available with this edition of SQL Server. Accordingly, encryption can be done either AES or TRIPLEDES. A master key is generated and database encrypted.

    Thanks,

    Sekhar

  • August 10, 2011 at 2:46 pm

    #1366934

    You are talking about transparent data encrustation if I am not mistaken. As far as this encryption is concerned, it is transparent to the application. That means you can write to it or read from it without any key. This only helps in physical file protection. Replication will not have any issue.

    Replication uses simple insert, update and delete statements using stored procs.

    -Roy

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

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