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]
MS Sql Server LazyDBA home page