Yes, check configuration into databases, sort order and charset...
-----Mensagem original-----
De: Edwards Ed
[mailto:mssqldba-ezmlmshield-x24052220.[Email address protected]
Enviada em: terça-feira, 31 de agosto de 2004 07:25
Para: LazyDBA Discussion
Assunto: RE: Migrate from 6.5 to 7.0
To All,
Can you convert a SQL Server 6.5 database to SQL Server 2000 using the
COPY DATABASE WIZARD?
-----Original Message-----
From: Thomas Anthony
[mailto:mssqldba-ezmlmshield-x81705216.[Email address protected]
Sent: Monday, August 30, 2004 8:08 AM
To: LazyDBA Discussion
Subject: RE: Migrate from 6.5 to 7.0
Response below is reasonable solution. Yes, you must convert; you can not
detach/attach nor backup/restore from 6.5 to 7.0.
For the one respondent concerning the default file name extensions, .mdf and
.ndf, these are defaults but the files can have any extension. The same
goes for .BAK, .TRN, and .DFN for FULL, LOG, and DIFFERENTIAL database
backups.
Sincerely,
Anthony Thomas, MCDBA, MCSA
-----Original Message-----
From: Rogerio Raymundo Dias [mailto:mssqldba-ezmlmshield-x10742357.[Email
address protected]
Sent: Wednesday, August 25, 2004 11:52 AM
To: LazyDBA Discussion
Subject: RES: Migrate from 6.5 to 7.0
Mery
To migrate databases in SQL6.5, extract DDL from tables and export data to
BCP files, verify code page and sort order from server SQL7; create database
in SQL7,execute DDL and import BCP files to new database in SQL7.0....the
best method to migration databases;;;
Rogério Dias
São Paulo - Brazil
-----Mensagem original-----
De: Dodge Eric
[mailto:mssqldba-ezmlmshield-x4589517.[Email address protected]
Enviada em: quarta-feira, 25 de agosto de 2004 12:56
Para: LazyDBA Discussion
Assunto: RE: Migrate from 6.5 to 7.0
Good article describing why
http://www.microsoft.com/technet/prodtechnol/sql/70/deploy/migrat.mspx
Thank You,
Eric Dodge
XIM
-----Original Message-----
From: Jim Dorame
[mailto:mssqldba-ezmlmshield-x55889790.[Email address protected]
Sent: Wednesday, August 25, 2004 11:39 AM
To: LazyDBA Discussion
Subject: RE: Migrate from 6.5 to 7.0
Mery,
You can not restore from 6.5 to 7.0. You have to do a
conversion.
-----Original Message-----
From: Mery Moreno
[mailto:mssqldba-ezmlmshield-x69314783.[Email address protected]
Sent: Wednesday, August 25, 2004 10:05 AM
To: LazyDBA Discussion
Subject: Migrate from 6.5 to 7.0
Gurus,
I am trying to migrate a database from sql server 6.5 to sql server
7.0. I was trying to export this database, but I was not able to do it
because I encountered a bunch of errors. Now I am trying to restore the
same database to a dev server that has sql server 7.0 installed. I also
encountered the following error:
Server: Msg 3242, Level 16, State 1, Line 1
The file on device 'D:\ftp downloads\RMS\riskmaster.dat' is not a valid
Microsoft Tape Format backup set.
Server: Msg 3013, Level 16, State 1, Line 1
Backup or restore operation terminating abnormally.
I am not using a tape to restore, I have my file on my D drive.
Here's is the syntax that I am using to restore the db.
RESTORE DATABASE RISKMASTER
FROM DISK = 'D:\ftp downloads\RMS\riskmaster.dat'
Is it possible to restore a db from 6.5 to 7.0? Please advise with best
method to performance this migration.
Thanks,
Mery B. Moreno
Database Administrator - DBA
Lakeland Regional Medical Center
Phone: 863-687-1100 Ext 2830
BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:Moreno, Mery
ORG:;I.S.
EMAIL;WORK;PREF:Mery.[Email address protected]
N:Moreno;Mery
TITLE:DBA
END:VCARD
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
***********************************************************************
NOTICE: This electronic mail message and any attached files are
confidential. The information is exclusively for the use of the
individual or entity intended as the recipient. If you are not the
intended recipient, any use, copying, printing, reviewing, retention,
disclosure, distribution or forwarding of the message or any attached
file is not authorized and is strictly prohibited. If you have received
this electronic mail message in error, please advise the sender by reply
electronic mail immediately and permanently delete the original
transmission, any attachments and any copies of this message from your
computer system.
***********************************************************************
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
MS Sql Server LazyDBA home page