Need To Get A Copy Of A Database From One Environment To Another.

Hi,

I have been experiencing difficulties achieving the above.

We have a secure network environment and the connection can only be established from within, not from outside, so basically, there is a rule that allows me to go outbound on port 5022 to our other network.

There is no domain trust relationship, so I have had to create Certificates and use these as the method of authentication.

I have managed to get this working on two other environments where there is two way communication enabled on port 5022.

I thought I might be able to fool it into forcing the mirroring without two-way communication by setting up mirroring in the environment and using the hosts file to change the actual IP address of the server, this didn't work. The mirroring monitor thought that mirroring was still active, but on the other server, the state never changed and was just waiting for something to happen.

I also thought I might be able to turn the transactional safety off, but only to find out that this can only be enabled in the Enterprise version of SQL Server.

The reason why I have been trying to get mirroring working this way, is due to a requirement for an encrypted connection, I know that with SQL Server mirroring you can choose the encrpytion method and the plan was to create snapshots of the database in the other environment, just so we could access the database.

I think we're at a stage where we will be willing to explore other possibilities, so if anyone could point me in the right direction, it would be greatly appreciated.

Please bear in mind, that we're not concerned with redundancy, this is purely to get the data from one point to another.

Thanks,
Akeel.