1.Sir I wanted to know if there exists a linked server to connect to a different application but it's data source has been updated recently then how can we make the changes? 2.Also can you make a video on what changes are required to do this using ssis packages, if it is presently using the linked server to make connection as you suggested earlier in the video?
Frankly speaking majority of the times I have used linked servers from sql to sql i.e from one sql server to another sql server and in this case we don't need to make any changes until unless the source sql server instance is same. I have not much worked on creating linked servers with different application. Sorry for that.
Excellent, very well explained!
Thank you Sir.
1.Sir I wanted to know if there exists a linked server to connect to a different application but it's data source has been updated recently then how can we make the changes?
2.Also can you make a video on what changes are required to do this using ssis packages, if it is presently using the linked server to make connection as you suggested earlier in the video?
Frankly speaking majority of the times I have used linked servers from sql to sql i.e from one sql server to another sql server and in this case we don't need to make any changes until unless the source sql server instance is same. I have not much worked on creating linked servers with different application. Sorry for that.
Hello sir, I have one query related to Linked server is there a way to download all the linked server scripts dynamically in file
Sorry I am not sure about such query or method.
can we create link server over public ip?
Sorry I am not sure about that, never done that thing.
Excellent, very well explained!
Thank you.