Wednesday, March 28, 2012

Migrating database from 7.0 to 2k

Hi,
I want to move a database from server A (Sql 7.0) to Server B (Sql 2000) in
the same domain.
I try exporting from A to B and work fine with the tables but it not tranfer
views.
There is any utility that i could download to migrate in a better way? If
yes, where to find it?
Thanks a lot,
Daniel Abellá
MCSE / MCT
UruguayThis is a multi-part message in MIME format.
--=_NextPart_000_0105_01C37D00.0FB3A7D0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Why don't you just do just do a backup and restore? Just make sure you =transfer the logins first.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Daniel_A" <dabella@.empower.edu.uy> wrote in message =news:e$zwwCSfDHA.620@.TK2MSFTNGP11.phx.gbl...
Hi,
I want to move a database from server A (Sql 7.0) to Server B (Sql 2000) =in
the same domain.
I try exporting from A to B and work fine with the tables but it not =tranfer
views.
There is any utility that i could download to migrate in a better way? =If
yes, where to find it?
Thanks a lot,
Daniel Abell=E1
MCSE / MCT
Uruguay
--=_NextPart_000_0105_01C37D00.0FB3A7D0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

Why don't you just do just do a backup =and restore? Just make sure you transfer the logins =first.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Daniel_A" =wrote in message news:e$zwwCSfDHA.620@.T=K2MSFTNGP11.phx.gbl...Hi,I want to move a database from server A (Sql 7.0) to Server B (Sql 2000) =inthe same domain.I try exporting from A to B and work fine with the =tables but it not tranferviews.There is any utility that i could =download to migrate in a better way? Ifyes, where to find it?Thanks a =lot,Daniel Abell=E1MCSE / =MCTUruguay

--=_NextPart_000_0105_01C37D00.0FB3A7D0--|||This is a multi-part message in MIME format.
--=_NextPart_000_00B4_01C37D38.0A7339B0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Click "From Device" in Enterprise Manager, or use Query Analyzer and the =RESTORE command.
-- Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=3Ddjq&as =ugroup=3Dmicrosoft.public.sqlserver
"Daniel_A" <dabella@.empower.edu.uy> wrote in message =news:uqYjmZSfDHA.2352@.TK2MSFTNGP09.phx.gbl...
Thanks for your answer tom.
I try wat you tell me. I back up the database and then try to restore =it in sql 2000 but i dont find an option to catch the file of the =backup. I try creating a backup set with that file but it seems not to =see it because it was not created in the same server.
any idea?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message =news:Oz$6dGSfDHA.1872@.TK2MSFTNGP09.phx.gbl...
Why don't you just do just do a backup and restore? Just make sure =you transfer the logins first.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Daniel_A" <dabella@.empower.edu.uy> wrote in message =news:e$zwwCSfDHA.620@.TK2MSFTNGP11.phx.gbl...
Hi,
I want to move a database from server A (Sql 7.0) to Server B (Sql =2000) in
the same domain.
I try exporting from A to B and work fine with the tables but it not =tranfer
views.
There is any utility that i could download to migrate in a better =way? If
yes, where to find it?
Thanks a lot,
Daniel Abell=E1
MCSE / MCT
Uruguay
--=_NextPart_000_00B4_01C37D38.0A7339B0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

Click "From Device" in Enterprise =Manager, or use Query Analyzer and the RESTORE command.
-- Tibor Karaszi, SQL Server MVPArchive at: http://groups.google.com/groups?oi=3Ddjq&as">http://groups.go=ogle.com/groups?oi=3Ddjq&as ugroup=3Dmicrosoft.public.sqlserver
"Daniel_A" =wrote in message news:uqYjmZSfDHA.2352=@.TK2MSFTNGP09.phx.gbl...
Thanks for your answer =tom.
I try wat you tell me. I back up the =database and then try to restore it in sql 2000 but i dont find an option to catch =the file of the backup. I try creating a backup set with that file but it seems =not to see it because it was not created in the same server.

any idea?

"Tom Moreau" = wrote in message news:Oz$6dGSfDHA.1872=@.TK2MSFTNGP09.phx.gbl...
Why don't you just do just do a =backup and restore? Just make sure you transfer the logins =first.
-- Tom

=---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql


"Daniel_A" =wrote in message news:e$zwwCSfDHA.620@.T=K2MSFTNGP11.phx.gbl...Hi,I want to move a database from server A (Sql 7.0) to Server B (Sql =2000) inthe same domain.I try exporting from A to B and work =fine with the tables but it not tranferviews.There is any utility =that i could download to migrate in a better way? Ifyes, where to find it?Thanks a lot,Daniel Abell=E1MCSE / MCTUruguay

--=_NextPart_000_00B4_01C37D38.0A7339B0--|||This is a multi-part message in MIME format.
--=_NextPart_000_0074_01C37D10.A58EE520
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Ok, i find it
But, when i try to restore it i receive error of SQL-DMO (ODBC SQLState: =42000) saying: "The backup set holds a backup of a database other than =the exsisting 'xxxx' database. RESTORE DATABASE is terminating =abnormaly.
...
"Tibor Karaszi" =<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se> wrote in =message news:#IhNLdSfDHA.460@.TK2MSFTNGP12.phx.gbl...
Click "From Device" in Enterprise Manager, or use Query Analyzer and =the RESTORE command.
-- Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=3Ddjq&as =ugroup=3Dmicrosoft.public.sqlserver
"Daniel_A" <dabella@.empower.edu.uy> wrote in message =news:uqYjmZSfDHA.2352@.TK2MSFTNGP09.phx.gbl...
Thanks for your answer tom.
I try wat you tell me. I back up the database and then try to =restore it in sql 2000 but i dont find an option to catch the file of =the backup. I try creating a backup set with that file but it seems not =to see it because it was not created in the same server.
any idea?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message =news:Oz$6dGSfDHA.1872@.TK2MSFTNGP09.phx.gbl...
Why don't you just do just do a backup and restore? Just make =sure you transfer the logins first.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Daniel_A" <dabella@.empower.edu.uy> wrote in message =news:e$zwwCSfDHA.620@.TK2MSFTNGP11.phx.gbl...
Hi,
I want to move a database from server A (Sql 7.0) to Server B (Sql =2000) in
the same domain.
I try exporting from A to B and work fine with the tables but it =not tranfer
views.
There is any utility that i could download to migrate in a better =way? If
yes, where to find it?
Thanks a lot,
Daniel Abell=E1
MCSE / MCT
Uruguay
--=_NextPart_000_0074_01C37D10.A58EE520
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#c0c0c0>
<DIV><FONT face=3DArial size=3D2>Ok, i find it</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>But, when i try to restore it i receive =error of SQL-DMO (ODBC SQLState: 42000) saying: "The backup set holds a backup of =a database other than the exsisting 'xxxx' database. RESTORE DATABASE is terminating abnormaly.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>...</FONT></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Tibor Karaszi" <<A =href=3D"mailto:tibor.please_reply_to_public_forum.karaszi@.cornerstone.se"=>tibor.please_reply_to_public_forum.karaszi@.cornerstone.se</A>> wrote in message <A =href=3D"news:#IhNLdSfDHA.460@.TK2MSFTNGP12.phx.gbl">news:#IhNLdSfDHA.460@.T=K2MSFTNGP12.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Click "From Device" in Enterprise =Manager, or use Query Analyzer and the RESTORE command.</FONT></DIV>
<DIV><BR>-- <BR>Tibor Karaszi, SQL Server MVP<BR>Archive at: <A =href=3D"http://groups.go=">http://groups.google.com/groups?oi=3Ddjq&as">http://groups.go=
ogle.com/groups?oi=3Ddjq&as</A> ugroup=3Dmicrosoft.public.sqlserver</DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=3Dltr style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Daniel_A" <<A =href=3D"mailto:dabella@.empower.edu.uy">dabella@.empower.edu.uy</A>> =wrote in message <A =href=3D"news:uqYjmZSfDHA.2352@.TK2MSFTNGP09.phx.gbl">news:uqYjmZSfDHA.2352=@.TK2MSFTNGP09.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks for your answer =tom.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I try wat you tell me. I back up =the database and then try to restore it in sql 2000 but i dont find an option to =catch the file of the backup. I try creating a backup set with that file =but it seems not to see it because it was not created in the same server.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>any idea?</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Tom Moreau" <<A =href=3D"mailto:tom@.dont.spam.me.cips.ca">tom@.dont.spam.me.cips.ca</A>>= wrote in message <A =href=3D"news:Oz$6dGSfDHA.1872@.TK2MSFTNGP09.phx.gbl">news:Oz$6dGSfDHA.1872=@.TK2MSFTNGP09.phx.gbl</A>...</DIV>
<DIV><FONT face=3DTahoma size=3D2>Why don't you just do just do a =backup and restore? Just make sure you transfer the logins =first.</FONT></DIV>
<DIV><BR>-- <BR>Tom</DIV>
<DIV> </DIV>
=<DIV>---<BR>T=homas A. Moreau, BSc, PhD, MCSE, MCDBA<BR>SQL Server MVP<BR>Columnist, =SQL Server Professional<BR>Toronto, ON Canada<BR><A =href=3D"www.pinnaclepublishing.com=">http://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=
/sql</A></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>"Daniel_A" <<A =href=3D"mailto:dabella@.empower.edu.uy">dabella@.empower.edu.uy</A>> =wrote in message <A =href=3D"news:e$zwwCSfDHA.620@.TK2MSFTNGP11.phx.gbl">news:e$zwwCSfDHA.620@.T=K2MSFTNGP11.phx.gbl</A>...</DIV>Hi,<BR><BR>I want to move a database from server A (Sql 7.0) to Server B (Sql =2000) in<BR>the same domain.<BR><BR>I try exporting from A to B and work =fine with the tables but it not tranfer<BR>views.<BR><BR>There is any =utility that i could download to migrate in a better way? If<BR>yes, where =to find it?<BR><BR>Thanks a lot,<BR><BR>Daniel Abell=E1<BR>MCSE / =MCT<BR>Uruguay<BR><BR></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTM=L>
--=_NextPart_000_0074_01C37D10.A58EE520--|||This is a multi-part message in MIME format.
--=_NextPart_000_0210_01C37D0A.09F5E240
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
You can use:
restore database MyDB
from disk =3D 'C:\temp\MyDB.bak'
with replace
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Daniel_A" <dabella@.empower.edu.uy> wrote in message =news:et#fnnSfDHA.620@.TK2MSFTNGP11.phx.gbl...
Ok, i find it
But, when i try to restore it i receive error of SQL-DMO (ODBC SQLState: =42000) saying: "The backup set holds a backup of a database other than =the exsisting 'xxxx' database. RESTORE DATABASE is terminating =abnormaly.
...
"Tibor Karaszi" =<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se> wrote in =message news:#IhNLdSfDHA.460@.TK2MSFTNGP12.phx.gbl...
Click "From Device" in Enterprise Manager, or use Query Analyzer and =the RESTORE command.
-- Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=3Ddjq&as =ugroup=3Dmicrosoft.public.sqlserver
"Daniel_A" <dabella@.empower.edu.uy> wrote in message =news:uqYjmZSfDHA.2352@.TK2MSFTNGP09.phx.gbl...
Thanks for your answer tom.
I try wat you tell me. I back up the database and then try to =restore it in sql 2000 but i dont find an option to catch the file of =the backup. I try creating a backup set with that file but it seems not =to see it because it was not created in the same server.
any idea?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message =news:Oz$6dGSfDHA.1872@.TK2MSFTNGP09.phx.gbl...
Why don't you just do just do a backup and restore? Just make =sure you transfer the logins first.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Daniel_A" <dabella@.empower.edu.uy> wrote in message =news:e$zwwCSfDHA.620@.TK2MSFTNGP11.phx.gbl...
Hi,
I want to move a database from server A (Sql 7.0) to Server B (Sql =2000) in
the same domain.
I try exporting from A to B and work fine with the tables but it =not tranfer
views.
There is any utility that i could download to migrate in a better =way? If
yes, where to find it?
Thanks a lot,
Daniel Abell=E1
MCSE / MCT
Uruguay
--=_NextPart_000_0210_01C37D0A.09F5E240
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.2800.1226" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#c0c0c0>
<DIV><FONT face=3DTahoma size=3D2>You can use:</FONT></DIV>
<DIV><FONT face=3DTahoma size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Courier New" size=3D2>restore database =MyDB</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2>from disk =3D ='C:\temp\MyDB.bak'</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2>with replace</FONT></DIV>
<DIV><BR>-- <BR>Tom</DIV>
<DIV> </DIV>
<DIV>---<BR>T=homas A. Moreau, BSc, PhD, MCSE, MCDBA<BR>SQL Server MVP<BR>Columnist, SQL =Server Professional<BR>Toronto, ON Canada<BR><A href=3D"www.pinnaclepublishing.com=">http://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=
/sql</A></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>"Daniel_A" <<A href=3D"mailto:dabella@.empower.edu.uy">dabella@.empower.edu.uy</A>> =wrote in message <A href=3D"news:et#fnnSfDHA.620@.TK2MSFTNGP11.phx.gbl">news:et#fnnSfDHA.620@.T=K2MSFTNGP11.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Ok, i find it</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>But, when i try to restore it i receive =error of SQL-DMO (ODBC SQLState: 42000) saying: "The backup set holds a backup of =a database other than the exsisting 'xxxx' database. RESTORE DATABASE is terminating abnormaly.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>...</FONT></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Tibor Karaszi" <<A =href=3D"mailto:tibor.please_reply_to_public_forum.karaszi@.cornerstone.se"=>tibor.please_reply_to_public_forum.karaszi@.cornerstone.se</A>> wrote in message <A =href=3D"news:#IhNLdSfDHA.460@.TK2MSFTNGP12.phx.gbl">news:#IhNLdSfDHA.460@.T=K2MSFTNGP12.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Click "From Device" in Enterprise =Manager, or use Query Analyzer and the RESTORE command.</FONT></DIV>
<DIV><BR>-- <BR>Tibor Karaszi, SQL Server MVP<BR>Archive at: <A =href=3D"http://groups.go=">http://groups.google.com/groups?oi=3Ddjq&as">http://groups.go=
ogle.com/groups?oi=3Ddjq&as</A> ugroup=3Dmicrosoft.public.sqlserver</DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=3Dltr style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Daniel_A" <<A =href=3D"mailto:dabella@.empower.edu.uy">dabella@.empower.edu.uy</A>> =wrote in message <A =href=3D"news:uqYjmZSfDHA.2352@.TK2MSFTNGP09.phx.gbl">news:uqYjmZSfDHA.2352=@.TK2MSFTNGP09.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks for your answer =tom.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I try wat you tell me. I back up =the database and then try to restore it in sql 2000 but i dont find an option to =catch the file of the backup. I try creating a backup set with that file =but it seems not to see it because it was not created in the same server.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>any idea?</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Tom Moreau" <<A =href=3D"mailto:tom@.dont.spam.me.cips.ca">tom@.dont.spam.me.cips.ca</A>>= wrote in message <A =href=3D"news:Oz$6dGSfDHA.1872@.TK2MSFTNGP09.phx.gbl">news:Oz$6dGSfDHA.1872=@.TK2MSFTNGP09.phx.gbl</A>...</DIV>
<DIV><FONT face=3DTahoma size=3D2>Why don't you just do just do a =backup and restore? Just make sure you transfer the logins =first.</FONT></DIV>
<DIV><BR>-- <BR>Tom</DIV>
<DIV> </DIV>
=<DIV>---<BR>T=homas A. Moreau, BSc, PhD, MCSE, MCDBA<BR>SQL Server MVP<BR>Columnist, =SQL Server Professional<BR>Toronto, ON Canada<BR><A =href=3D"www.pinnaclepublishing.com=">http://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=
/sql</A></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>"Daniel_A" <<A =href=3D"mailto:dabella@.empower.edu.uy">dabella@.empower.edu.uy</A>> =wrote in message <A =href=3D"news:e$zwwCSfDHA.620@.TK2MSFTNGP11.phx.gbl">news:e$zwwCSfDHA.620@.T=K2MSFTNGP11.phx.gbl</A>...</DIV>Hi,<BR><BR>I want to move a database from server A (Sql 7.0) to Server B (Sql =2000) in<BR>the same domain.<BR><BR>I try exporting from A to B and work =fine with the tables but it not tranfer<BR>views.<BR><BR>There is any =utility that i could download to migrate in a better way? If<BR>yes, where =to find it?<BR><BR>Thanks a lot,<BR><BR>Daniel Abell=E1<BR>MCSE / =MCT<BR>Uruguay<BR><BR></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTM=L>
--=_NextPart_000_0210_01C37D0A.09F5E240--

No comments:

Post a Comment