You can dump a SQL Server 4.2 user database and load it on a SQL Server 6.0 server (although you cannot do this for master.) However, this capability is one-way only, as you cannot dump a SQL Server 6.0 database and load it on a SQL Server 4.2 server.
When loading a SQL Server 4.2 user database on a SQL Server 6.0 server, all necessary comments must exist in syscomments. SQL Server cannot upgrade all objects from SQL Server 4.2 databases to SQL Server 6.0 if you have deleted data from the text column in the syscomments table.
Also, you may encounter conflicts with the new SQL Server 6.0 keywords. If you do, after loading the database, you can change the conflicting table or object name and alter the applications that access those objects so that they use the new names. For a list of the new keywords, see the Microsoft SQL Server Transact-SQL Reference.
Note For information about language, statement, query, and other compatibility issues between SQL Server 6.0 and SQL Server 4.2 databases, see the compatibility information provided in the Microsoft SQL Server Transact-SQL Reference.