February 11, 2010 at 3:54 pm
I have just migrated to sql 2008 and am running sql 2000 side by side as a couple of databases need to stay in 2000.
In one of my SPs, I reference data from a 2000 DB from within sql2008. Currently it can't find the database because it's in a different instance. How can I reference the DB in a different instance?
(talking to a non-pro, here)
Thanks,
Sam
February 11, 2010 at 4:14 pm
Each instance is completely separate, as though they were on separate machines. One cannot reference the other easily.
You can set up a linked server between the instances. It's not hard, and you can read a little about getting started here: http://www.sqlservercentral.com/articles/Distributed+Queries/anintroductiontolinkedservers/1366/
Be aware of security, and I would set a proxy between the servers rather than passing through all security unless you can keep them in sync.
The other thing to be aware of is that you will need to make a four part reference when calling the remote stored procedure (server.db.schema.object)
February 11, 2010 at 4:41 pm
In addition to what Steve has stated, why do those databases need to stay on the 2000 instance? Can you move them to 2008 and leave them in 80 (2000) compatibility mode?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 11, 2010 at 6:12 pm
The DB belongs to a commercial (off the shelf) application that has not yet upgraded. I read and use data from their database.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply