Connecting from sql 2000 to sql 6.5

**** Post for FREE via your newsreader at post.mcse.ms ****
Hello.
I have two computers: one runing on SQL 6.5, other runing on SQL 2000. I
want to connect to SQL 6.5 server from computer running on SQL 2000, but I
can't see server runing on SQL 6.5. My SQL 6.5 is with sp5. How can I solve
this problem?
The real problem is that I have database on SQL6.5 and I want to transfer it
to SQL2000.
Thank you.
Darius
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
*** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.mcse.ms
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=Hi Darius.
I'm not sure why you can't "see" your 6.5 server from your 2000 server, how
are you "looking"? There could be anything from networking issues through
netlib or permission problems..
However, transfer is fraught with danger from 6.5 to 2000 as there are a
variety of things that just don't transfer easily. There is an upgrade
wizard for this purpose - have you looked at it? You should be able to find
it on your 2000 server - Start->Programs->Microsoft SQL Server-Switch->SQL
Server Upgrade Wizard. This is definitely the professional approach, unless
your transfer is dead simple, using only basic table structures etc..
Regards,
Greg Linwood
SQL Server MVP
"Darius" <darius.ram@.takas.lt> wrote in message
news:4046f21c@.post.mcse.ms...
> **** Post for FREE via your newsreader at post.mcse.ms ****
> Hello.
> I have two computers: one runing on SQL 6.5, other runing on SQL 2000. I
> want to connect to SQL 6.5 server from computer running on SQL 2000, but I
> can't see server runing on SQL 6.5. My SQL 6.5 is with sp5. How can I
solve
> this problem?
> The real problem is that I have database on SQL6.5 and I want to transfer
it
> to SQL2000.
> Thank you.
> Darius
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> *** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
> http://www.mcse.ms
> Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=|||Darius wrote:

> The real problem is that I have database on SQL6.5 and I want to
> transfer it to SQL2000.
> Thank you.
SQL Server 6.5 internal data structure is very different from that in SQL
7.0 and 2000, that is why you have to migrate it. You need to script your
SQL 6.5 database and DTS/BCP (I suggest BCP) the data from 6.5 to a newly
created 2000 database. You may also consider using SQL Server Upgrade
Wizard.
Check out the section "SQL Server 6.5 upgrade" index entry in the SQL Server
2000 Books Online.
See the following articles:
INF: Frequently Asked Questions - SQL Server 2000 - Upgrade
http://support.microsoft.com/defaul...b;en-us;q261334
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||**** Post for FREE via your newsreader at post.mcse.ms ****

> I'm not sure why you can't "see" your 6.5 server from your 2000 server,
how
> are you "looking"? There could be anything from networking issues through
> netlib or permission problems..
I am trying to register SQL 6.5 server on SQL 2000 with enterprise manager,
but it can't see 6.5 server. If I install SQL 2000 on both computers then
problems dissapear. i don't know why?
Darius
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
*** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.mcse.ms
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=|||7.0 or 2000 EM cannot work against 6.5 or earlier. You need EM 6.5 for that.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Darius" <darius.ram@.takas.lt> wrote in message
news:40470958@.post.mcse.ms...
> **** Post for FREE via your newsreader at post.mcse.ms ****
>
> how
through
> I am trying to register SQL 6.5 server on SQL 2000 with enterprise
manager,
> but it can't see 6.5 server. If I install SQL 2000 on both computers then
> problems dissapear. i don't know why?
> Darius
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> *** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
> http://www.mcse.ms
> Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=|||**** Post for FREE via your newsreader at post.mcse.ms ****
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OU6DiedAEHA.1468@.tk2msftngp13.phx.gbl...
> 7.0 or 2000 EM cannot work against 6.5 or earlier. You need EM 6.5 for
that.
You want to say all i need is 6.5 enterprise manager? or i need all sql 6.5
installation?
Darius
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
*** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.mcse.ms
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=|||If you want to administer a 6.5 machine from another machine, you only need
to do a client install on that machine.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Darius" <darius.ram@.takas.lt> wrote in message
news:404714cd$1@.post.mcse.ms...
> **** Post for FREE via your newsreader at post.mcse.ms ****
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:OU6DiedAEHA.1468@.tk2msftngp13.phx.gbl...
> that.
> You want to say all i need is 6.5 enterprise manager? or i need all sql
6.5
> installation?
> Darius
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> *** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
> http://www.mcse.ms
> Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=|||On Thu, 4 Mar 2004 11:09:45 +0100, "Darius" wrote:

>I have two computers: one runing on SQL 6.5, other runing on SQL 2000. I
>want to connect to SQL 6.5 server from computer running on SQL 2000, but I
>can't see server runing on SQL 6.5. My SQL 6.5 is with sp5. How can I solve
>this problem?
G'day Darius,
From reading the rest of the thread, you are trying to look at your 6.5
server from 2000 Enterprise Manager - which doesn't work.
Note, however, that you can use 2000's Query Analyser to connect to your
6.5 server, thus you can query, examine tables and stored procs and
views etc., and execute any admin tasks you need to via SQL.

>The real problem is that I have database on SQL6.5 and I want to transfer i
t
>to SQL2000.
You will find that DTS in SQL Server 2000 can help you do this. The
Enterprise Manager tools for managing databases aren't compatible with
SQL Server 6.5, but DTS is, and the wizards will allow you to copy
across the tables and data.
However, you should probably take a step back and examine the 6.5
database(s) first, to see whether you want to just copy them over, or
whether you might be better adjusting the design for 2000 better. As
Sebastian says, check out the "SQL Server 6.5 upgrade" topic in BOL.
For starters, you can use Query Analyser to examine your 6.5
database(s). Then you can work up a plan of how you will rebuild in
2000. If all you will be doing is replicating it without modification,
then you'd be best off using SQL Server 6.5 Enterprise Manager to script
out the tables, views and stored procedures, then running these scripts
on SQL Server 2000 to build the database.
regards,
Ross.
--
"There is more to life than simply increasing its speed." - Mahatma Gandhi