Viewing 3 posts - 1 through 3 (of 3 total)
Will check it out, thank you!
July 17, 2015 at 12:42 pm
#1813401
Ok thanks Lowell, that's definitely a possibility.
Regarding the compatibility level, yes I'm trying that too. I'm actually in the process of restoring these databases to a test 2014 server...
July 17, 2015 at 7:53 am
#1813290
Yes, you have the setup exactly right. Interesting... so I would then need to create a synonym for every table accessed in TheData from PROD, correct?
July 16, 2015 at 2:34 pm
#1813128