Moving DB in 6.5 
Author Message
 Moving DB in 6.5
What are my options for moving a DB to a different location in MS SQL6.5?
I've done it in 7.0 using the Detach/Attach method.  Is it the same in 6.5?
Thanks in advance.
Kevin


Fri, 15 Aug 2003 22:55:47 GMT
 Moving DB in 6.5

This is a mess in 6.x. If you want to move at binary level, you do a backup. But in
order to be able to load that backup at destination server, you first have to create
the database. With the same layout (order and size of data and log allocations) as on
the originating server. Run the proc sp_help_revdatabase at the originating server, it
reverse-engineers the necessary CREATE/ALTER DATABASE statements needed at the dest
server.

If you want to move the database files per se (not going though backup restore) it is
even more messy. I won't do an outline here, just point to the DISK REINIT and DISK
REFIT commands which are the 6.x's counterparts of sp_attach_db.

--
Tibor Karaszi, SQL Server MVP
FAQ from Neil at: http://www.sqlserverfaq.com
Please reply to the newsgroup only, not by email.

Quote:

> What are my options for moving a DB to a different location in MS SQL6.5?
> I've done it in 7.0 using the Detach/Attach method.  Is it the same in 6.5?
> Thanks in advance.
> Kevin



Fri, 15 Aug 2003 23:41:17 GMT
 Moving DB in 6.5
Thanks for the help and for such a quick response.
So it would probably be easier to upgrade to SQL 7.x and go from there?
Thanks again.
Kevin



Quote:
> This is a mess in 6.x. If you want to move at binary level, you do a
backup. But in
> order to be able to load that backup at destination server, you first have
to create
> the database. With the same layout (order and size of data and log
allocations) as on
> the originating server. Run the proc sp_help_revdatabase at the

originating server, it
Quote:
> reverse-engineers the necessary CREATE/ALTER DATABASE statements needed at
the dest
> server.

> If you want to move the database files per se (not going though backup
restore) it is
> even more messy. I won't do an outline here, just point to the DISK REINIT
and DISK
> REFIT commands which are the 6.x's counterparts of sp_attach_db.

> --
> Tibor Karaszi, SQL Server MVP
> FAQ from Neil at: http://www.sqlserverfaq.com
> Please reply to the newsgroup only, not by email.




- Show quoted text -

Quote:
> > What are my options for moving a DB to a different location in MS
SQL6.5?
> > I've done it in 7.0 using the Detach/Attach method.  Is it the same in
6.5?
> > Thanks in advance.
> > Kevin



Sat, 16 Aug 2003 00:04:52 GMT
 Moving DB in 6.5

Quote:
> So it would probably be easier to upgrade to SQL 7.x and go from there?

Hard to say. If you understand 6.x architecture, this is not a difficult thing. The
difficult thing is to get a grasp of the 6.x architecture. Answer is as it usually is:
It depends...
:-)

--
Tibor Karaszi, SQL Server MVP
FAQ from Neil at: http://www.sqlserverfaq.com
Please reply to the newsgroup only, not by email.

Quote:

> Thanks for the help and for such a quick response.
> So it would probably be easier to upgrade to SQL 7.x and go from there?
> Thanks again.
> Kevin



> > This is a mess in 6.x. If you want to move at binary level, you do a
> backup. But in
> > order to be able to load that backup at destination server, you first have
> to create
> > the database. With the same layout (order and size of data and log
> allocations) as on
> > the originating server. Run the proc sp_help_revdatabase at the
> originating server, it
> > reverse-engineers the necessary CREATE/ALTER DATABASE statements needed at
> the dest
> > server.

> > If you want to move the database files per se (not going though backup
> restore) it is
> > even more messy. I won't do an outline here, just point to the DISK REINIT
> and DISK
> > REFIT commands which are the 6.x's counterparts of sp_attach_db.

> > --
> > Tibor Karaszi, SQL Server MVP
> > FAQ from Neil at: http://www.sqlserverfaq.com
> > Please reply to the newsgroup only, not by email.



> > > What are my options for moving a DB to a different location in MS
> SQL6.5?
> > > I've done it in 7.0 using the Detach/Attach method.  Is it the same in
> 6.5?
> > > Thanks in advance.
> > > Kevin



Sat, 16 Aug 2003 00:03:04 GMT
 Moving DB in 6.5
Doesn't make much since to learn 6.5 architecture when ultimately SQL will
be upgraded to 7.  I am more familiar with 7 and have no intention of
regression.
Ok, thanks for all your help Tibor.  I'm sure we'll talk again.
Kevin



Quote:
> > So it would probably be easier to upgrade to SQL 7.x and go from there?

> Hard to say. If you understand 6.x architecture, this is not a difficult
thing. The
> difficult thing is to get a grasp of the 6.x architecture. Answer is as it
usually is:
> It depends...
> :-)

> --
> Tibor Karaszi, SQL Server MVP
> FAQ from Neil at: http://www.sqlserverfaq.com
> Please reply to the newsgroup only, not by email.




Quote:
> > Thanks for the help and for such a quick response.
> > So it would probably be easier to upgrade to SQL 7.x and go from there?
> > Thanks again.
> > Kevin

> > Tibor Karaszi


- Show quoted text -

Quote:

> > > This is a mess in 6.x. If you want to move at binary level, you do a
> > backup. But in
> > > order to be able to load that backup at destination server, you first
have
> > to create
> > > the database. With the same layout (order and size of data and log
> > allocations) as on
> > > the originating server. Run the proc sp_help_revdatabase at the
> > originating server, it
> > > reverse-engineers the necessary CREATE/ALTER DATABASE statements
needed at
> > the dest
> > > server.

> > > If you want to move the database files per se (not going though backup
> > restore) it is
> > > even more messy. I won't do an outline here, just point to the DISK
REINIT
> > and DISK
> > > REFIT commands which are the 6.x's counterparts of sp_attach_db.

> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > FAQ from Neil at: http://www.sqlserverfaq.com
> > > Please reply to the newsgroup only, not by email.



> > > > What are my options for moving a DB to a different location in MS
> > SQL6.5?
> > > > I've done it in 7.0 using the Detach/Attach method.  Is it the same
in
> > 6.5?
> > > > Thanks in advance.
> > > > Kevin



Sat, 16 Aug 2003 01:25:44 GMT
 Moving DB in 6.5

Quote:
> Doesn't make much since to learn 6.5 architecture when ultimately SQL will
> be upgraded to 7.  I am more familiar with 7 and have no intention of
> regression.

That is true. 6.5 is a 5 year old release now....

--
Tibor Karaszi, SQL Server MVP
FAQ from Neil at: http://www.sqlserverfaq.com
Please reply to the newsgroup only, not by email.

Quote:

> Doesn't make much since to learn 6.5 architecture when ultimately SQL will
> be upgraded to 7.  I am more familiar with 7 and have no intention of
> regression.
> Ok, thanks for all your help Tibor.  I'm sure we'll talk again.
> Kevin



> > > So it would probably be easier to upgrade to SQL 7.x and go from there?

> > Hard to say. If you understand 6.x architecture, this is not a difficult
> thing. The
> > difficult thing is to get a grasp of the 6.x architecture. Answer is as it
> usually is:
> > It depends...
> > :-)

> > --
> > Tibor Karaszi, SQL Server MVP
> > FAQ from Neil at: http://www.sqlserverfaq.com
> > Please reply to the newsgroup only, not by email.



> > > Thanks for the help and for such a quick response.
> > > So it would probably be easier to upgrade to SQL 7.x and go from there?
> > > Thanks again.
> > > Kevin

> > > Tibor Karaszi


> > > > This is a mess in 6.x. If you want to move at binary level, you do a
> > > backup. But in
> > > > order to be able to load that backup at destination server, you first
> have
> > > to create
> > > > the database. With the same layout (order and size of data and log
> > > allocations) as on
> > > > the originating server. Run the proc sp_help_revdatabase at the
> > > originating server, it
> > > > reverse-engineers the necessary CREATE/ALTER DATABASE statements
> needed at
> > > the dest
> > > > server.

> > > > If you want to move the database files per se (not going though backup
> > > restore) it is
> > > > even more messy. I won't do an outline here, just point to the DISK
> REINIT
> > > and DISK
> > > > REFIT commands which are the 6.x's counterparts of sp_attach_db.

> > > > --
> > > > Tibor Karaszi, SQL Server MVP
> > > > FAQ from Neil at: http://www.sqlserverfaq.com
> > > > Please reply to the newsgroup only, not by email.



> > > > > What are my options for moving a DB to a different location in MS
> > > SQL6.5?
> > > > > I've done it in 7.0 using the Detach/Attach method.  Is it the same
> in
> > > 6.5?
> > > > > Thanks in advance.
> > > > > Kevin



Sat, 16 Aug 2003 14:58:49 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. Move db from 6.5 to 7; Newbie Question

2. Need help in moving SQL Server 6.5 db.

3. moving web DB app from 6.5 to 2000

4. Moving SQL 6.5 DB to another server

5. How to move 6.5 db's to a 7 server

6. How to move a DB Device SQL v 6.5

7. Moving a DB 6.5

8. moving a db from 6.5 to 7.0

9. Using DTS to move data from a SQl-Server 6.5 DB (Newbie question)

10. Error in moving SQL Server 6.5 db to another system

11. moving a db 6.5 to 7.0

12. How do I move a 6.5 DB from network1 to 7.0 on network2


 
Powered by phpBB® Forum Software