Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
SQL
ce
clients
clustering
connect
datamining
datawarehouse
dts
fulltext
jdbcdriver
msde
mseq
newusers
notificationsvcs
odbc
olap
programming
replication
reportingsvcs
security
securitytools
server
setup
sqlxml.viewmapper
tools
xml
  
 
date: Thu, 28 Aug 2008 07:54:01 -0700,    group: microsoft.public.sqlserver.server        back       


Migrating from SQL 6.5 to SQL 2005   
I've read that I can't copy databases directly from SQL 6.5 to SQL 2005. Can 
I copy databases from SQL 6.5 to SQL 2000?

If not, I will need to install SQL 7.0. Will it install on XP Pro?

I have an install CD from MSDN but I can't find any product keys for a CD 
this old. Any ideas?

Thanks,

BrianR
date: Thu, 28 Aug 2008 07:54:01 -0700   author:   BrianR

Re: Migrating from SQL 6.5 to SQL 2005   
Brian

upgrade you server to 2000 and then upgrade to 2005

see the link bellow for more details on upgrading 6.5 to 2000
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx


I have an install CD from MSDN but I can't find any product keys for a CD
this old. Any ideas?

Do you mean cd key of sql 2000 if so

open regedit.exe and locate the following node

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Registration

your cd is stored in "cd_key"


vinu
http://oneplace4sql.blogspot.com/



"BrianR"  wrote in message 
news:A7B88F31-4505-4C04-B077-D19D5001CDB6@microsoft.com...
> I've read that I can't copy databases directly from SQL 6.5 to SQL 2005. 
> Can
> I copy databases from SQL 6.5 to SQL 2000?
>
> If not, I will need to install SQL 7.0. Will it install on XP Pro?
>
> I have an install CD from MSDN but I can't find any product keys for a CD
> this old. Any ideas?
>
> Thanks,
>
> BrianR
date: Thu, 28 Aug 2008 16:10:30 +0100   author:   vinu

Re: Migrating from SQL 6.5 to SQL 2005   
Basically the same upgrade wizard that is in 7.0 also came with 2000. There's a whole section in 
2000 Books Online on how to upgrade from 6.5. Basically the Wizard connects to your 6.5 instance and 
based on that creates the database, the objects and finally copies over the data from the 6.5 
install to your 2000 install. So, no in-place upgrade of any type.

You cannot restore or attach 6.5 backups/databases on 7.0, 2000, 2005 or 2008. Upgrade wizard is the 
way to go and the most recent version it was shipped with was 2000.

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"BrianR"  wrote in message 
news:A7B88F31-4505-4C04-B077-D19D5001CDB6@microsoft.com...
> I've read that I can't copy databases directly from SQL 6.5 to SQL 2005. Can
> I copy databases from SQL 6.5 to SQL 2000?
>
> If not, I will need to install SQL 7.0. Will it install on XP Pro?
>
> I have an install CD from MSDN but I can't find any product keys for a CD
> this old. Any ideas?
>
> Thanks,
>
> BrianR
date: Thu, 28 Aug 2008 17:12:14 +0200   author:   Tibor Karaszi

Re: Migrating from SQL 6.5 to SQL 2005   
Thanks for the information about hte CD key. I wasn't aware of that.

I guess did forget some information. I can't currently upgrade from 6.5 to 
2000 because I need to keep the old 6.5 version around for a while. So now 
I'm stuck trying to find a 2000 cd key. Again, I have the MSDN CDs but I 
can't find the keys for applications that far back.

BrianR

"vinu" wrote:

> Brian
> 
> upgrade you server to 2000 and then upgrade to 2005
> 
> see the link bellow for more details on upgrading 6.5 to 2000
> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx
> 
> 
> I have an install CD from MSDN but I can't find any product keys for a CD
> this old. Any ideas?
> 
> Do you mean cd key of sql 2000 if so
> 
> open regedit.exe and locate the following node
> 
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Registration
> 
> your cd is stored in "cd_key"
> 
> 
> vinu
> http://oneplace4sql.blogspot.com/
> 
> 
> 
> "BrianR"  wrote in message 
> news:A7B88F31-4505-4C04-B077-D19D5001CDB6@microsoft.com...
> > I've read that I can't copy databases directly from SQL 6.5 to SQL 2005. 
> > Can
> > I copy databases from SQL 6.5 to SQL 2000?
> >
> > If not, I will need to install SQL 7.0. Will it install on XP Pro?
> >
> > I have an install CD from MSDN but I can't find any product keys for a CD
> > this old. Any ideas?
> >
> > Thanks,
> >
> > BrianR 
> 
> 
>
date: Thu, 28 Aug 2008 08:33:01 -0700   author:   BrianR

Re: Migrating from SQL 6.5 to SQL 2005   
Since I have to keep my v6.5 computer around, I need to either install 7.0 or 
2000 on another computer. This is now where I'm in a bind. I have the MSDN 
install CDs (Developer Edition) for it but I can't find the CD keys for 
either of these. When I try and look up the keys under MSDN (online), it 
doesn't go back that far. If I can copy databases from 6.5 to 2000 then that 
is what I would like to do. I've 

What's the best solution?

BrianR

"Tibor Karaszi" wrote:

> Basically the same upgrade wizard that is in 7.0 also came with 2000. There's a whole section in 
> 2000 Books Online on how to upgrade from 6.5. Basically the Wizard connects to your 6.5 instance and 
> based on that creates the database, the objects and finally copies over the data from the 6.5 
> install to your 2000 install. So, no in-place upgrade of any type.
> 
> You cannot restore or attach 6.5 backups/databases on 7.0, 2000, 2005 or 2008. Upgrade wizard is the 
> way to go and the most recent version it was shipped with was 2000.
> 
> -- 
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
> 
> 
> "BrianR"  wrote in message 
> news:A7B88F31-4505-4C04-B077-D19D5001CDB6@microsoft.com...
> > I've read that I can't copy databases directly from SQL 6.5 to SQL 2005. Can
> > I copy databases from SQL 6.5 to SQL 2000?
> >
> > If not, I will need to install SQL 7.0. Will it install on XP Pro?
> >
> > I have an install CD from MSDN but I can't find any product keys for a CD
> > this old. Any ideas?
> >
> > Thanks,
> >
> > BrianR 
> 
>
date: Thu, 28 Aug 2008 08:51:01 -0700   author:   BrianR

Re: Migrating from SQL 6.5 to SQL 2005   
As far as I recall, SQL Server never required CD keys, at least not the MSDN version. IT is either 
not at all required or already filled in for you.

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"BrianR"  wrote in message 
news:70066B35-1283-414C-8243-B4E3C61A0CE0@microsoft.com...
> Since I have to keep my v6.5 computer around, I need to either install 7.0 or
> 2000 on another computer. This is now where I'm in a bind. I have the MSDN
> install CDs (Developer Edition) for it but I can't find the CD keys for
> either of these. When I try and look up the keys under MSDN (online), it
> doesn't go back that far. If I can copy databases from 6.5 to 2000 then that
> is what I would like to do. I've
>
> What's the best solution?
>
> BrianR
>
> "Tibor Karaszi" wrote:
>
>> Basically the same upgrade wizard that is in 7.0 also came with 2000. There's a whole section in
>> 2000 Books Online on how to upgrade from 6.5. Basically the Wizard connects to your 6.5 instance 
>> and
>> based on that creates the database, the objects and finally copies over the data from the 6.5
>> install to your 2000 install. So, no in-place upgrade of any type.
>>
>> You cannot restore or attach 6.5 backups/databases on 7.0, 2000, 2005 or 2008. Upgrade wizard is 
>> the
>> way to go and the most recent version it was shipped with was 2000.
>>
>> -- 
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>>
>> "BrianR"  wrote in message
>> news:A7B88F31-4505-4C04-B077-D19D5001CDB6@microsoft.com...
>> > I've read that I can't copy databases directly from SQL 6.5 to SQL 2005. Can
>> > I copy databases from SQL 6.5 to SQL 2000?
>> >
>> > If not, I will need to install SQL 7.0. Will it install on XP Pro?
>> >
>> > I have an install CD from MSDN but I can't find any product keys for a CD
>> > this old. Any ideas?
>> >
>> > Thanks,
>> >
>> > BrianR
>>
>>
date: Thu, 28 Aug 2008 17:54:16 +0200   author:   Tibor Karaszi

Re: Migrating from SQL 6.5 to SQL 2005   
I only had time to try installing 7.0 this morning and it did ask for a CD 
key. I'll try 2000 later on today and hopefully you are right.

BrianR

"Tibor Karaszi" wrote:

> As far as I recall, SQL Server never required CD keys, at least not the MSDN version. IT is either 
> not at all required or already filled in for you.
> 
> -- 
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
> 
> 
> "BrianR"  wrote in message 
> news:70066B35-1283-414C-8243-B4E3C61A0CE0@microsoft.com...
> > Since I have to keep my v6.5 computer around, I need to either install 7.0 or
> > 2000 on another computer. This is now where I'm in a bind. I have the MSDN
> > install CDs (Developer Edition) for it but I can't find the CD keys for
> > either of these. When I try and look up the keys under MSDN (online), it
> > doesn't go back that far. If I can copy databases from 6.5 to 2000 then that
> > is what I would like to do. I've
> >
> > What's the best solution?
> >
> > BrianR
> >
> > "Tibor Karaszi" wrote:
> >
> >> Basically the same upgrade wizard that is in 7.0 also came with 2000. There's a whole section in
> >> 2000 Books Online on how to upgrade from 6.5. Basically the Wizard connects to your 6.5 instance 
> >> and
> >> based on that creates the database, the objects and finally copies over the data from the 6.5
> >> install to your 2000 install. So, no in-place upgrade of any type.
> >>
> >> You cannot restore or attach 6.5 backups/databases on 7.0, 2000, 2005 or 2008. Upgrade wizard is 
> >> the
> >> way to go and the most recent version it was shipped with was 2000.
> >>
> >> -- 
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://sqlblog.com/blogs/tibor_karaszi
> >>
> >>
> >> "BrianR"  wrote in message
> >> news:A7B88F31-4505-4C04-B077-D19D5001CDB6@microsoft.com...
> >> > I've read that I can't copy databases directly from SQL 6.5 to SQL 2005. Can
> >> > I copy databases from SQL 6.5 to SQL 2000?
> >> >
> >> > If not, I will need to install SQL 7.0. Will it install on XP Pro?
> >> >
> >> > I have an install CD from MSDN but I can't find any product keys for a CD
> >> > this old. Any ideas?
> >> >
> >> > Thanks,
> >> >
> >> > BrianR
> >>
> >> 
> 
>
date: Thu, 28 Aug 2008 09:01:24 -0700   author:   BrianR

Re: Migrating from SQL 6.5 to SQL 2005   
=?Utf-8?B?QnJpYW5S?=  wrote in
news:1A693DCC-2CC2-4B22-90F1-20C909E245D5@microsoft.com: 

> I only had time to try installing 7.0 this morning and it did ask for
> a CD key. I'll try 2000 later on today and hopefully you are right.

Since you are only intending to use 2000 as a staging post, MSDE Edition A 
(=2000) might suffice - it's a free download:

http://www.microsoft.com/downloads/details.aspx?FamilyID=413744D1-A0BC-
479F-BAFA-E4B278EB9147&displaylang=en

Of course it has some limitations, e.g. database size <= 4GB
date: Thu, 28 Aug 2008 18:35:14 GMT   author:   Chris.Cheney

Re: Migrating from SQL 6.5 to SQL 2005   
Thanks for the tip Chris. I've downloaded it and I'll give it a shot. Will I 
have any issue with having SQL 2005 Dev. Ed. already installed? Will they 
work side by side?

BrianR

"Chris.Cheney" wrote:

> =?Utf-8?B?QnJpYW5S?=  wrote in
> news:1A693DCC-2CC2-4B22-90F1-20C909E245D5@microsoft.com: 
> 
> > I only had time to try installing 7.0 this morning and it did ask for
> > a CD key. I'll try 2000 later on today and hopefully you are right.
> 
> Since you are only intending to use 2000 as a staging post, MSDE Edition A 
> (=2000) might suffice - it's a free download:
> 
> http://www.microsoft.com/downloads/details.aspx?FamilyID=413744D1-A0BC-
> 479F-BAFA-E4B278EB9147&displaylang=en
> 
> Of course it has some limitations, e.g. database size <= 4GB
>
date: Thu, 28 Aug 2008 15:03:01 -0700   author:   BrianR

Re: Migrating from SQL 6.5 to SQL 2005   
What tool do I use to copy the databases from 6.5 to MSDE2000A?

"Chris.Cheney" wrote:

> =?Utf-8?B?QnJpYW5S?=  wrote in
> news:1A693DCC-2CC2-4B22-90F1-20C909E245D5@microsoft.com: 
> 
> > I only had time to try installing 7.0 this morning and it did ask for
> > a CD key. I'll try 2000 later on today and hopefully you are right.
> 
> Since you are only intending to use 2000 as a staging post, MSDE Edition A 
> (=2000) might suffice - it's a free download:
> 
> http://www.microsoft.com/downloads/details.aspx?FamilyID=413744D1-A0BC-
> 479F-BAFA-E4B278EB9147&displaylang=en
> 
> Of course it has some limitations, e.g. database size <= 4GB
>
date: Thu, 28 Aug 2008 19:34:00 -0700   author:   BrianR

Re: Migrating from SQL 6.5 to SQL 2005   
I doubt that MSDE comes with the upgrading wizard...

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Chris.Cheney"  wrote in message 
news:Xns9B08C740B4387ChrisCheneytesconet@69.16.176.253...
> =?Utf-8?B?QnJpYW5S?=  wrote in
> news:1A693DCC-2CC2-4B22-90F1-20C909E245D5@microsoft.com:
>
>> I only had time to try installing 7.0 this morning and it did ask for
>> a CD key. I'll try 2000 later on today and hopefully you are right.
>
> Since you are only intending to use 2000 as a staging post, MSDE Edition A
> (=2000) might suffice - it's a free download:
>
> http://www.microsoft.com/downloads/details.aspx?FamilyID=413744D1-A0BC-
> 479F-BAFA-E4B278EB9147&displaylang=en
>
> Of course it has some limitations, e.g. database size <= 4GB
date: Fri, 29 Aug 2008 09:56:31 +0200   author:   Tibor Karaszi

Re: Migrating from SQL 6.5 to SQL 2005   
"Tibor Karaszi"  wrote in 
news:eoahBzaCJHA.2292@TK2MSFTNGP02.phx.gbl:

> I doubt that MSDE comes with the upgrading wizard...
> 

True :-(

And in response to the other postings: you might look at

http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-msde/1501/How-to-
upgrade-from-SQL-Server-6-5-to-MSDE-2000

which I had not seen previous to my original reply (which I had based on 
the stated intention of going from 6.5 via 2000). Sorry for misleading you.

You are no doubt aware of: 
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx

As to side by side - I don't think there should be a problem. FWIW I run 
2005 Express side by side with 2000 Developers Edition.
date: Fri, 29 Aug 2008 09:41:55 GMT   author:   Chris.Cheney

Re: Migrating from SQL 6.5 to SQL 2005   
I was finally able to track down and install SQL Server 2000 Dev. Ed. but 
that has led to another small problem. When I use Server Enterprise Mgr and 
try to register this new sql 2000 server it doesn't show up in the list of 
available servers to register. I made sure the server was up and running but 
it doesn't find it in the list. Is there a configuration somewhere I missed 
during installation?

BrianR

"Chris.Cheney" wrote:

> "Tibor Karaszi"  wrote in 
> news:eoahBzaCJHA.2292@TK2MSFTNGP02.phx.gbl:
> 
> > I doubt that MSDE comes with the upgrading wizard...
> > 
> 
> True :-(
> 
> And in response to the other postings: you might look at
> 
> http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-msde/1501/How-to-
> upgrade-from-SQL-Server-6-5-to-MSDE-2000
> 
> which I had not seen previous to my original reply (which I had based on 
> the stated intention of going from 6.5 via 2000). Sorry for misleading you.
> 
> You are no doubt aware of: 
> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx
> 
> As to side by side - I don't think there should be a problem. FWIW I run 
> 2005 Express side by side with 2000 Developers Edition.
>
date: Fri, 29 Aug 2008 06:35:00 -0700   author:   BrianR

Re: Migrating from SQL 6.5 to SQL 2005   
I was able to get the server to show up under the list of available servers 
by disabling my windows firewall (XP Pro SP3). I don't quite understand why 
the Enter. Mgr couldn't find the server when they were both running on the 
same (local) machine. I find that a little strange. I was able to get the new 
2000 server registered.

What's the best method to copy my 6.5 db(s) to my new 2000 server? I tried 
using the export wizard but it errored out saying one of the logins wasn't on 
the destination server (2000). I thought that's what it was doing for me was 
copying the whole database including the logins under the database.

What am I missing? By the way, if you haven't noticed I'm fairly new with 
databases especially SQL (any flavor).

BrianR

"BrianR" wrote:

> I was finally able to track down and install SQL Server 2000 Dev. Ed. but 
> that has led to another small problem. When I use Server Enterprise Mgr and 
> try to register this new sql 2000 server it doesn't show up in the list of 
> available servers to register. I made sure the server was up and running but 
> it doesn't find it in the list. Is there a configuration somewhere I missed 
> during installation?
> 
> BrianR
> 
> "Chris.Cheney" wrote:
> 
> > "Tibor Karaszi"  wrote in 
> > news:eoahBzaCJHA.2292@TK2MSFTNGP02.phx.gbl:
> > 
> > > I doubt that MSDE comes with the upgrading wizard...
> > > 
> > 
> > True :-(
> > 
> > And in response to the other postings: you might look at
> > 
> > http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-msde/1501/How-to-
> > upgrade-from-SQL-Server-6-5-to-MSDE-2000
> > 
> > which I had not seen previous to my original reply (which I had based on 
> > the stated intention of going from 6.5 via 2000). Sorry for misleading you.
> > 
> > You are no doubt aware of: 
> > http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx
> > 
> > As to side by side - I don't think there should be a problem. FWIW I run 
> > 2005 Express side by side with 2000 Developers Edition.
> >
date: Fri, 29 Aug 2008 06:44:01 -0700   author:   BrianR

Re: Migrating from SQL 6.5 to SQL 2005   
I continue to make progress....
I'm able to copy most of the tables to the SQL2000 server but it's erroring 
out during the transfer.

I thought that transfer from 6.5 to 2000 was going to be pretty painless. 
The wizard was suppose to handle any translation issues. Here's one of the 
errors:

Error at Destination for Row number 1. Errors encountered so far in this 
task:1
The statment has been termnated.
Violation of PRIMARY KEY constrain 'PK__tblAward__32AB8735'. Cannot insert 
duplicate key in object 'tblAward'.

I need some help deciphering this one. Any one??? Is there a setting 
somewhere that I missed?

BrianR

"BrianR" wrote:

> I was able to get the server to show up under the list of available servers 
> by disabling my windows firewall (XP Pro SP3). I don't quite understand why 
> the Enter. Mgr couldn't find the server when they were both running on the 
> same (local) machine. I find that a little strange. I was able to get the new 
> 2000 server registered.
> 
> What's the best method to copy my 6.5 db(s) to my new 2000 server? I tried 
> using the export wizard but it errored out saying one of the logins wasn't on 
> the destination server (2000). I thought that's what it was doing for me was 
> copying the whole database including the logins under the database.
> 
> What am I missing? By the way, if you haven't noticed I'm fairly new with 
> databases especially SQL (any flavor).
> 
> BrianR
> 
> "BrianR" wrote:
> 
> > I was finally able to track down and install SQL Server 2000 Dev. Ed. but 
> > that has led to another small problem. When I use Server Enterprise Mgr and 
> > try to register this new sql 2000 server it doesn't show up in the list of 
> > available servers to register. I made sure the server was up and running but 
> > it doesn't find it in the list. Is there a configuration somewhere I missed 
> > during installation?
> > 
> > BrianR
> > 
> > "Chris.Cheney" wrote:
> > 
> > > "Tibor Karaszi"  wrote in 
> > > news:eoahBzaCJHA.2292@TK2MSFTNGP02.phx.gbl:
> > > 
> > > > I doubt that MSDE comes with the upgrading wizard...
> > > > 
> > > 
> > > True :-(
> > > 
> > > And in response to the other postings: you might look at
> > > 
> > > http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-msde/1501/How-to-
> > > upgrade-from-SQL-Server-6-5-to-MSDE-2000
> > > 
> > > which I had not seen previous to my original reply (which I had based on 
> > > the stated intention of going from 6.5 via 2000). Sorry for misleading you.
> > > 
> > > You are no doubt aware of: 
> > > http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx
> > > 
> > > As to side by side - I don't think there should be a problem. FWIW I run 
> > > 2005 Express side by side with 2000 Developers Edition.
> > >
date: Fri, 29 Aug 2008 07:48:01 -0700   author:   BrianR

Re: Migrating from SQL 6.5 to SQL 2005   
=?Utf-8?B?QnJpYW5S?=  wrote in
news:B316F144-4A19-4ACB-8CD3-061CA98BD303@microsoft.com: 

> I continue to make progress....
> I'm able to copy most of the tables to the SQL2000 server but it's
> erroring out during the transfer.
> 
> I thought that transfer from 6.5 to 2000 was going to be pretty
> painless. The wizard was suppose to handle any translation issues.
> Here's one of the errors:
> 
> Error at Destination for Row number 1. Errors encountered so far in
> this task:1
> The statment has been termnated.
> Violation of PRIMARY KEY constrain 'PK__tblAward__32AB8735'. Cannot
> insert duplicate key in object 'tblAward'.
> 
> I need some help deciphering this one. Any one??? Is there a setting 
> somewhere that I missed?
<snip>

>> What am I missing? By the way, if you haven't noticed I'm fairly new
>> with databases especially SQL (any flavor).

tblAward has (been defined with) a PRIMARY KEY constraint.

Values used for a PRIMARY KEY must be unique.

That error message is generated when a new row is being added but the key 
for the new row matches an existing key in the table, i.e. it would break 
the uniqueness constraint.

I note that the error refers to row 1 so I wonder if you are perhaps trying 
to rerun this part of the transfer.

HTH
date: Fri, 29 Aug 2008 15:59:32 GMT   author:   Chris.Cheney

Re: Migrating from SQL 6.5 to SQL 2005   
When I looked at this tblAward table, it only has one row. What other choices 
do I have to copy a database from 6.5 to 2000? I thought a simple "Export 
Data" would have executed without error.

Thanks for your help Chris.

BrianR

"Chris.Cheney" wrote:

> =?Utf-8?B?QnJpYW5S?=  wrote in
> news:B316F144-4A19-4ACB-8CD3-061CA98BD303@microsoft.com: 
> 
> > I continue to make progress....
> > I'm able to copy most of the tables to the SQL2000 server but it's
> > erroring out during the transfer.
> > 
> > I thought that transfer from 6.5 to 2000 was going to be pretty
> > painless. The wizard was suppose to handle any translation issues.
> > Here's one of the errors:
> > 
> > Error at Destination for Row number 1. Errors encountered so far in
> > this task:1
> > The statment has been termnated.
> > Violation of PRIMARY KEY constrain 'PK__tblAward__32AB8735'. Cannot
> > insert duplicate key in object 'tblAward'.
> > 
> > I need some help deciphering this one. Any one??? Is there a setting 
> > somewhere that I missed?
> <snip>
> 
> >> What am I missing? By the way, if you haven't noticed I'm fairly new
> >> with databases especially SQL (any flavor).
> 
> tblAward has (been defined with) a PRIMARY KEY constraint.
> 
> Values used for a PRIMARY KEY must be unique.
> 
> That error message is generated when a new row is being added but the key 
> for the new row matches an existing key in the table, i.e. it would break 
> the uniqueness constraint.
> 
> I note that the error refers to row 1 so I wonder if you are perhaps trying 
> to rerun this part of the transfer.
> 
> HTH
>
date: Fri, 29 Aug 2008 09:09:00 -0700   author:   BrianR

Re: Migrating from SQL 6.5 to SQL 2005   
=?Utf-8?B?QnJpYW5S?=  wrote in
news:5DC10865-C145-439D-B2C7-2FB4E8797431@microsoft.com: 

> When I looked at this tblAward table, it only has one row.

Is that the table on 6.5 or 2000? You haven't said whether or not there was 
an attempt to write the table twice. Also, a NULL primary key field (which 
I believe is possible on 6.5) might be a problem.

> What other
> choices do I have to copy a database from 6.5 to 2000? I thought a
> simple "Export Data" would have executed without error.

Perhaps see

http://www.mydatabasesupport.com/forums/sqlserver-tools/201942-sql-server-
6-5-data-conversion.html

http://msdn.microsoft.com/en-us/library/ms177398(SQL.90).aspx

(I Googled on "transfer sql server 6.5 database")

Chris
date: Fri, 29 Aug 2008 17:10:35 GMT   author:   Chris.Cheney

Re: Migrating from SQL 6.5 to SQL 2005   
The funny thing is when I look at both DBs (using enterprise mgr), the table 
in both 6.5 and 2000 look the same. It's like it went ahead and copied the 
table. I deleted the DB and tried to copy again and got the same errors.

BrianR

"Chris.Cheney" wrote:

> =?Utf-8?B?QnJpYW5S?=  wrote in
> news:5DC10865-C145-439D-B2C7-2FB4E8797431@microsoft.com: 
> 
> > When I looked at this tblAward table, it only has one row.
> 
> Is that the table on 6.5 or 2000? You haven't said whether or not there was 
> an attempt to write the table twice. Also, a NULL primary key field (which 
> I believe is possible on 6.5) might be a problem.
> 
> > What other
> > choices do I have to copy a database from 6.5 to 2000? I thought a
> > simple "Export Data" would have executed without error.
> 
> Perhaps see
> 
> http://www.mydatabasesupport.com/forums/sqlserver-tools/201942-sql-server-
> 6-5-data-conversion.html
> 
> http://msdn.microsoft.com/en-us/library/ms177398(SQL.90).aspx
> 
> (I Googled on "transfer sql server 6.5 database")
> 
> Chris
>
date: Fri, 29 Aug 2008 10:27:01 -0700   author:   BrianR

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us