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 […]
2020-01-02
7,036 reads
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
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
I recently needed to ensure that a Power BI imported dataset would be refreshed...
Hi all, I need to migrate a SQL 2012 database that has a few...
Comments posted to this topic are about the item Controlling Intelligent Query Processing Features
I have this function, but I wanted to pass a table so as to...
Ask SSC