I do like the active geo replication, but one finally question on that.

How do I access the secondary reporting when the secondary has the same name as the...

After doing some studying, it may be that active geo replication would be a solution.

1.Create a primary database in central region.
2. create a secondary database in east...

I was thinking of setting up SQL Server in Azure VMs.  But after Grant's reply, I may need to rethink that.

If I understand right, we are located in...

This post was a while ago, but I thought I would reply.

Have you heard of data sync services?  I am looking to do the same thing.  I have...

I tried connecting inside the network with the same public IP.  That didn't work.

I checked all of the TCP protocols and all are enabled.

I am thinking...

Sue,

I was able to ping the server from the pc.
I am testing telnet now.

Thanks.

Thanks Drew. I actually have not seen the offset function. I will review it as well.

Thanks.

That is so excellent. I figured I was just missing something. it worked as needed. Thanks so much!

Luis,

I followed all of that up to "use the File Connection as the source".

I'm not sure where you are setting the source to be the file connection?

Thanks.

Tony

I would like to have an app built also.

However, as I mentioned, I am the new guy on the block. Senior guy, but still the new guy.

I don't want...

Hello,

I've only been here a week. However, no pattern yet. Update script. Insert rows. They come in from about 6 developers.

Thanks.

Tony

Thanks Mike.

I know if Integration services were installed. However, Integration services are not installed on this server. The import.and export wizard is there. The package was created...