export data

Exporting Data with PowerShell

  • Article

Recently I had the need to help someone download some data from SQL Server as a part of an automated process. In this case, the person wanted to use PowerShell (PoSh), since they were performing a few other actions with PoSh as well. This article is a short tutorial on exporting data from SQL Server […]

5 (8)

2020-01-02

13,443 reads

Export data to an earlier SQL Server version

  • Article

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.

2012-05-10

3,518 reads

Blogs

What is the CONTROL permission?

By

One of the most powerful permissions available in SQL Server is control. But what...

Daily Coping 19 Jan 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 1)

By

Welcome to a new year, and a new look at what I’ve learned in...

Read the latest Blogs

Forums

Deadlock - What to do next?

By krypto69

Hi, I have a job that keeps getting a deadlock victim error and  fails....

XML Vs Non-XML

By IT researcher

I am using SQL Server 2008 R2. While using XML data type and  XQuery...

Staging or UAT Environment

By VastSQL

Hi Experts, Currently, we are using the enterprise edition of SQL Server 2014 in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers