November 28, 2011 at 8:38 pm
HI,
Any possible to query and report generate from different domain ? example (venter ) other domain ( pretect)
1. Linked server or ( replciation) - > which one is best ?
Thaks
Jermi
November 28, 2011 at 9:45 pm
Are you trying to query a server in another domain? Is there a trust relationship between the domains?
Linked servers may work, but it depends on the volumn of data you need to query and where the joins between data occur. Replication may also be viable as it woul bring the data local for reporting.
Here is the problem, you really haven't given anyone enough information to really provide you with a good answer.
November 28, 2011 at 10:07 pm
Log shipping could work
SSIS could work
Please give us more details as to what you are trying to accomplish.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 28, 2011 at 10:43 pm
I need to setup below query:
1) We have two sites Silverton and Port Elizabeth, the data from Silverton needs to be read and reports need to be generated for Silverton site from Port Elizabeth. Is it possible to link both the servers?
2) The server in Silverton is behind a firewall and hence we will not be able to access the server the usual way. We have to get to the firewall team to open up ports are provide us with specific access to the server.
3) The Server at Silverton is running SQL Server 2008 R2 Standard edition.
4) The server at Port Elizabeth is running SQL Server 2005 Standard edition
November 28, 2011 at 10:59 pm
You can create a linked server for that. Coordinate with firewall team and create the connection.
You can also create an export/import job that exports the data from one and ftp's it to the other site, import the data and then run your joins there.
There are multiple ways to do this.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply