Database migration from SQL 2000 to SQL 2005

Hi folks,
Can somebody post a link which has information about migrating databases
from SQL Server 2000 (32 bit) to SQL Server 2005 64 bit. Your help is
greatly appreciated..
Thanks in advance,
Venkat
--
*** Sent via Developersdex http://www.examnotes.net ***these could be a start, even though it states 2000 64bit and not 2005...
http://www.microsoft.com/sql/soluti...ingto64bit.mspx
http://searchsqlserver.techtarget.c...tml?bucket=NEWS
Immy
Immy
"Venkat" <nospam_venkat_asp@.yahoo.co.uk> wrote in message
news:uCauqdpmGHA.4536@.TK2MSFTNGP04.phx.gbl...
> Hi folks,
> Can somebody post a link which has information about migrating databases
> from SQL Server 2000 (32 bit) to SQL Server 2005 64 bit. Your help is
> greatly appreciated..
> Thanks in advance,
> Venkat
> --
> *** Sent via Developersdex http://www.examnotes.net ***|||I am pretty sure that moving a 2000 32 bit database to 2005 64 bit is just a
matter of detaching the DB from 2000 server and attaching it to the 2005
server. 2005 64 bit supports this...
"Immy" wrote:

> these could be a start, even though it states 2000 64bit and not 2005...
> http://www.microsoft.com/sql/soluti...ingto64bit.mspx
> http://searchsqlserver.techtarget.c...tml?bucket=NEWS
> Immy
> Immy
> "Venkat" <nospam_venkat_asp@.yahoo.co.uk> wrote in message
> news:uCauqdpmGHA.4536@.TK2MSFTNGP04.phx.gbl...
>
>

Database Link supported with Oracle 9i?

I'm getting ready to link my SQL Server 2000 database to my legacy Oracle 9i
database via linked server and I was wondering if Microsoft supported such a
configuration.
tks
kmcclare@.hotmail.com
Yes, you can access Oracle from SQL Server via a linked server, provided you
have the required oracle drives (SQL*Net I believe) installed on the SQL
Server box. SQL Server Books Online has examples. See sp_addlinkedserver and
sp_addlinkedsrvlogin in SQL Server Books Online.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Ken McClaren" <kmcclare@.hotmail.com> wrote in message
news:e$FC1CmbEHA.904@.TK2MSFTNGP09.phx.gbl...
I'm getting ready to link my SQL Server 2000 database to my legacy Oracle 9i
database via linked server and I was wondering if Microsoft supported such a
configuration.
tks
kmcclare@.hotmail.com
|||These KB articles might help you incase you run into any issues.
Q280106 HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in SQL
Q259959 INFO: Steps to Debug Connectivity Issues to an Oracle Server
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
|||I've had a number of problems upgrading from 8i to 9i and in the end
I've stayed with the 8i client on the sql server and that works
perfectly. I'm sure I read somewhere that 9i hasn't been fully tested by
MS, although I might have dreamt that!
g.
http://www.sqlskunkworks.com
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Database Link supported with Oracle 9i?

I'm getting ready to link my SQL Server 2000 database to my legacy Oracle 9i
database via linked server and I was wondering if Microsoft supported such a
configuration.
tks
kmcclare@.hotmail.comYes, you can access Oracle from SQL Server via a linked server, provided you
have the required oracle drives (SQL*Net I believe) installed on the SQL
Server box. SQL Server Books Online has examples. See sp_addlinkedserver and
sp_addlinkedsrvlogin in SQL Server Books Online.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Ken McClaren" <kmcclare@.hotmail.com> wrote in message
news:e$FC1CmbEHA.904@.TK2MSFTNGP09.phx.gbl...
I'm getting ready to link my SQL Server 2000 database to my legacy Oracle 9i
database via linked server and I was wondering if Microsoft supported such a
configuration.
tks
kmcclare@.hotmail.com|||These KB articles might help you incase you run into any issues.
Q280106 HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in SQL
Q259959 INFO: Steps to Debug Connectivity Issues to an Oracle Server
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||I've had a number of problems upgrading from 8i to 9i and in the end
I've stayed with the 8i client on the sql server and that works
perfectly. I'm sure I read somewhere that 9i hasn't been fully tested by
MS, although I might have dreamt that!
g.
http://www.sqlskunkworks.com
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Database Link

Hi!
Is it possible to use database links on MS SQL-Server 2000, like on Oracle? If its possibe, what is the syntax and can i create a database link from Microsoft SQL Server 2000 to Oracle?
NickI think what you are talking about is a Linked server . Look up more on linked servers in Books Online.And ... Yes ... you can create a linked server to Oracle