Hi,
backup/restore and detach/attach is one way capable, from SQL 7 to SQL
2000. How about DTS from SQL 2000 to SQL 7?
Jun Chen
This posting is provided "AS IS" with no warranties, and confers no rights.
backup/restore and detach/attach is one way capable, from SQL 7 to SQL
2000. How about DTS from SQL 2000 to SQL 7?
Jun Chen
This posting is provided "AS IS" with no warranties, and confers no rights.
1. Copying database from SQL server 2000 to remote SQL server 7.0
You can't go backwards in versions. You can restore from a 7.0 to a 2000
but not the other way around.
--
Andrew J. Kelly, SQL Server MVP
2. select only record that match on the left table
3. copying sql server 7 database to sql server 2000 w/ no remote access
5. Is there any way to convert sql server 2000 database to sql server 7.0 database
6. T-SQL Syntax - Flagging a "Change of Value" in a repeated field.
7. how to connect remote sql server 2000 from my local sql server 2000
8. encrypting/decrypting database
9. Migrating an SQL Server 7.0 database to an SQL Server 2000
10. Restoring SQL Server 7.0 database to SQL Server 2000 Environment Question
11. Restore database from SQL Server 2000 to SQL Server 7.0
12. Restoring msdb database from SQL Server 7.0 backup to SQL Server 2000
13. Importing SQL Server 7.0 database to SQL Server 2000