Tips
Export data to an earlier SQL Server version
I have data in a SQL Server database that I need to get to an older version of SQL Server. I tried the backup and restore method, but received an error indicating that this wasn't allowed. I also tried to detach and attach the database, but that operation failed too. I understand that typical methods I use to move the database around don't work when I have to work with an earlier SQL Server version. What can I do to get the data out? This is a simple database and I want to spend a minimal amount of effort. Check out this tip to learn more.
SQL Server 2000 vs SQL Server 2005 SSIS Import and Export Wizard
The SQL Server Import/Export Wizard is a way to either perform a one-time data import/export, or create a DTS/SSIS package that can be further developed. Because the Import/Export Wizard is a part of Data Transformation Services, it was re-written in SQL Server 2005, as was the entire SQL Server Integration Services process. Because of this, the methods of accessing the Import and Export Wizard have changed.
Top 10
Export data to an earlier SQL Server version
I have data in a SQL Server database that I need to get to an older version of SQL Server. I tried the backup and restore method, but received an error indicating that this wasn't allowed. I also tried to detach and attach the database, but that operation failed too. I understand that typical methods I use to move the database around don't work when I have to work with an earlier SQL Server version. What can I do to get the data out? This is a simple database and I want to spend a minimal amount of effort. Check out this tip to learn more.
SQL Server 2000 vs SQL Server 2005 SSIS Import and Export Wizard
The SQL Server Import/Export Wizard is a way to either perform a one-time data import/export, or create a DTS/SSIS package that can be further developed. Because the Import/Export Wizard is a part of Data Transformation Services, it was re-written in SQL Server 2005, as was the entire SQL Server Integration Services process. Because of this, the methods of accessing the Import and Export Wizard have changed.
Last 10
Export data to an earlier SQL Server version
I have data in a SQL Server database that I need to get to an older version of SQL Server. I tried the backup and restore method, but received an error indicating that this wasn't allowed. I also tried to detach and attach the database, but that operation failed too. I understand that typical methods I use to move the database around don't work when I have to work with an earlier SQL Server version. What can I do to get the data out? This is a simple database and I want to spend a minimal amount of effort. Check out this tip to learn more.
SQL Server 2000 vs SQL Server 2005 SSIS Import and Export Wizard
The SQL Server Import/Export Wizard is a way to either perform a one-time data import/export, or create a DTS/SSIS package that can be further developed. Because the Import/Export Wizard is a part of Data Transformation Services, it was re-written in SQL Server 2005, as was the entire SQL Server Integration Services process. Because of this, the methods of accessing the Import and Export Wizard have changed.
