locked
Is it possible to make SQL2000 encrypted syncronization RRS feed

  • Question

  • Hi,
    I have two servers farm:
    One in enother town and one is in my place.
    Each farm have one CRM2000 (SP2) server and one SQL2000 (standart edition) server (all servers have win server 2003 32bit).
    Those servers connected to firewalls on both sides.
    I want to make syncronization between SQL servers on both farms, but I want that the database that will transferred from one SQL server to another, will be encrypted to make sure that database that transferred from one server to another will not change or sabotaged through.
    Is it possible in SQL2000 standart edition?

    thank's
    Igal.gri
    Sunday, August 1, 2010 8:29 AM

Answers

  • As Uri Dimant pointed out correctly, using SQL Server 2000 you can not have encrypted synchoronization.

    You can consider to upgrade to SQL Server 2008 to use the Transparent Data Encryption feature

    Alternativly consider third party tools like Red Gate.

    However since you are on SQL Server 2000 which mainstream support has ended, I would advise to upgrade the SQL Server.


    Sivaprasad S http://sivasql.blogspot.com Please click the Mark as Answer button if a post solves your problem!
    • Marked as answer by Tom Li - MSFT Monday, August 9, 2010 1:41 AM
    Tuesday, August 3, 2010 2:43 AM

All replies

  • I afraid NO. The only safety way is to backup database and give the file to the  person who is in police's accompaniment to deliver the database to another server....

    I am not laughing , I have had one client who does it in reallity


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Sunday, August 1, 2010 9:12 AM
  • Thank you for answer!

    So, I understand that if I want to make synchronization between SQL servers on both farms that will be encrypted to make sure that database that transferred from one server to another will not change or sabotaged through, I need to upgrade to SQL2005? Is no other way with SQL2000?

    Igal

    Sunday, August 1, 2010 11:09 AM
  • You are still on SQL Server 2000?? Shame on you :-)))) 

    In  your case  you are be able using Log Shipping only or Replication, have  you considered  those functions ?


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Sunday, August 1, 2010 11:26 AM
  • Can I make it encrypted to make sure that database that transferred from one server to another will not change or sabotaged through?

    My target is to able that two DB's servers in different areas can be synchronized.

    Igal

    Sunday, August 1, 2010 12:24 PM
  • Igal....

    I have already answered that queston... SQL Server 2008 has a new feature named transparent data encryption (TDE)

    http://msdn.microsoft.com/en-us/library/cc278098(SQL.100).aspx


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Sunday, August 1, 2010 1:03 PM
  • Igal....

    I have already answered that queston... SQL Server 2008 has a new feature named transparent data encryption (TDE)

    http://msdn.microsoft.com/en-us/library/cc278098(SQL.100).aspx


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Sunday, August 1, 2010 1:03 PM
  • As Uri Dimant pointed out correctly, using SQL Server 2000 you can not have encrypted synchoronization.

    You can consider to upgrade to SQL Server 2008 to use the Transparent Data Encryption feature

    Alternativly consider third party tools like Red Gate.

    However since you are on SQL Server 2000 which mainstream support has ended, I would advise to upgrade the SQL Server.


    Sivaprasad S http://sivasql.blogspot.com Please click the Mark as Answer button if a post solves your problem!
    • Marked as answer by Tom Li - MSFT Monday, August 9, 2010 1:41 AM
    Tuesday, August 3, 2010 2:43 AM