ow to fetch the data from one server to another server that are connected through lan. ...... Help me out
fetching the data
Collapse
X
-
You can create linked servers using http://msdn.microsoft.com/en-us/library/ms190479.aspx
Then query across them using syntax like
Code:select colNames from LocalTable,[ExternalServerName].ExternalDB].[ExternalUser].[ExternalTable]
-
see i know this is not a tutorial clases but then also i am asking this ques coz i need it urgent sorry for this ....
well my ques is i am having two pc A and B with both the db name av and table containing tok in both db. what i want is to fetch the data from pc A (one month) into the pc B . My boss want the query in the batch file i tried but not gettingComment
-
1.) You need to write full words. Some of us can't follow all that short hand language and hippy stuff. I didn't understand half of what you posted above.
2.) It's not important to tell us that it's urgent. That won't change how we will reply.
3.) Be clear in explaining what you want to do. At this stage I don't know if you want to
a.) Export data from one database to another or
b.) Query data from a database on a remote server
c.) Run a script that references two database on two different computers.
Regardless, no one is going to give you a full step by step guide that you are going to just blindly follow. This is important data to some people so you will need to put a lot of effort into understanding a suggested solution. First you'll have to put effort into explaining yourself thoughComment
-
Code:sp_addlinkedserver('sqlserver2008') SET IDENTITY_INSERT tblphndata ON Insert Into BKP2008.avqms.dbo.tblphndata Select * From sqlserver2008.avqm.dbo.Tbltoken SET IDENTITY_INSERT tblphndata off
Comment
Comment