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.

Setup SQL Server on Amazon RDS

by Steve Jones

SQLServerCentral.com

SQL Server 2008 R2

Learn how you can set up a new SQL Server instance painlessly on Amazon's Relational Database Service (RDS)

SQL Server on RDS

by Steve Jones

SQLServerCentral.com

Editorial

Amazon now offers SQL Server 2008 R2 in their RDS service. It's an easy way to get working with SQL Server with a minimal investment.

Transaction Replication Latency Diagnosis

by Paul Brewer

SQLServerCentral.com

PerfMon

Identify resource bottlenecks in a stressed transaction replication topology using PERFMON/PAL and system wait stats

How to Create an Indicator and Gauge Report in SSRS

by Additional Articles

Database Journal

Reporting Services (SSRS)

SQL Server Reporting Services provides several ways to analyze the data; a few of them are creating reports with indicators and Gauges. Indicators are minimal gauges that convey the state of a single data value at a glance and are mostly used to represent the state value of Key Performance Indicator (KPI, a measurable value which has business significance with a specific target or goal that indicates whether things are going good or bad).

The Colocated Dangers

by Steve Jones

SQLServerCentral.com

Editorial

An outage at SQLServerCentral reminded Steve Jones that it's not "if" a disaster will occur, but "when" it will occur that should have you preparing for a disaster at some point in the future.

Deciding between COALESCE and ISNULL in SQL Server

by Additional Articles

MSSQLTips.com

When writing T-SQL, a lot of developers use either COALESCE or ISNULL in order to provide a default value in cases where the input is NULL. The two functions do have quite different behavior and it is important to understand the qualitative differences between them when using them in your code.