does sql clone works with different certificates
hi
I dont currently have nor use sql clone, I just heard about it, so if my question is too basic, or not relevant please just let me know about what my next step should be.
I was wondering if I could have a database in live with its own certificate lets say C_my_client_2024.cer and I have a uat environment where I want to use sql clone to refresh the same database (different name if possible)
and in this uat environment I have the same certificate as live. So I am correct is the assumption that it will all work?
also, what if I had a different certificate, lets say on a different server, would sql clone still work? Or the certificate would not allow it? In other words, how much certificates and encryption affect sql clone? cheers
I dont currently have nor use sql clone, I just heard about it, so if my question is too basic, or not relevant please just let me know about what my next step should be.
I was wondering if I could have a database in live with its own certificate lets say C_my_client_2024.cer and I have a uat environment where I want to use sql clone to refresh the same database (different name if possible)
and in this uat environment I have the same certificate as live. So I am correct is the assumption that it will all work?
also, what if I had a different certificate, lets say on a different server, would sql clone still work? Or the certificate would not allow it? In other words, how much certificates and encryption affect sql clone? cheers
Answers
Not sure that I understand your question.
SQL Clone will create an Image of the source database. By either connecting directing to the live source database or from a backup file of source database. The SQL Clone Image is point-in-time copy of the source database.
Once the Image is created, you can then create clone databases from the image on as many SQL Instances as required. The host machine for the clone requires an install of the SQL Clone Agent and the account provided to the SQL Clone Agent service will require read, write, modify permissions to the storage location of SQL Clone Image.
This help document explains in further detail how SQL Clone works.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com