Last post Jan 20, 2011 11:28 AM by robert0304
Jan 20, 2011 09:05 AM|robert0304|LINK
My company has decided to copy a database from one server to another. I am concerned it will affect all the reports i have done. Will it just be a case of changing the dataset/source name in visual studios or is it more complex than that?
Jan 20, 2011 11:01 AM|BoogleC|LINK
Nope, if you're using a global connection string (which you should be :)) then all you do is change that. Unless you've specifically described the servername before database objects you should be fine.
So as long as you DID NOT DO:
dbo.MYSERVER.Table.Column - everything will work :)
Jan 20, 2011 11:28 AM|robert0304|LINK
Thats great news, thanks. I did think that was the case but wasnt sure.