Microsoft's SQL Server Migration Assistant lets you move your data and schema to different SQL Servers. Here's what you need to know about the tool. Image: Dilok/Adobe Stock The Microsoft SQL Server ...
For instance, if you copy a SQL 2000 database to SQL Server 2008, the new copy is an upgrade to the new internal format but retains a Compatibility Level of “80” which represents SQL 2000 aka SQL 8.0.