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 (7)

2020-01-02

7,036 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

Daily Coping 10 Jul 2020

By

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

Daily Coping 9 Jul 2020

By

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

Refreshing a Power BI Dataset in Azure Data Factory

By

I recently needed to ensure that a Power BI imported dataset would be refreshed...

Read the latest Blogs

Forums

Migrate database with encrypted columns to SQL 2016

By shahgols

Hi all, I need to migrate a SQL 2012 database that has a few...

Controlling Intelligent Query Processing Features

By Kathi Kellenberger

Comments posted to this topic are about the item Controlling Intelligent Query Processing Features

To use the same function to pass table name as a parameter

By Kenean

I have this function, but I wanted to pass a table so as to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers