December 27, 2005 at 7:46 pm
We have two servers.
One is running SQL 7.0 on Windows SBS 4.x
The other is running SQL 2000 on Windows SBS 2003.
We have total access to all databases.
When we detach the databases we need from the SQL 7.0 and attach them to the SQL 2000 everything in the enterprise manager is fine.
However, the application (Visual FoxPro) asks us to create two "database devices" in order to use the system.
Is there a way to export the "database devices" to SQL 2000 (which does not use database devices)?
December 29, 2005 at 10:25 am
v7.0 database to SQL2000 ??? Well in order to do that you have to perform backup v7.0 copy the file(s) and restore them on SQL2000. Things should be converted during the load I believe. But remember, you cannot take a SQL2000 databse and restore it to SQL v7.0.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
December 29, 2005 at 10:42 am
You might have forgotten users. Search sp_help_revlogin on Google for the script to help you move users. It's an MS KB item.
December 29, 2005 at 10:46 am
You are correct Steve (it's one of those 'automatic' things) ... Here's the link:
http://support.microsoft.com/default.aspx?kbid=246133
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply