Can this be done?

Question

Can this be done?

Viewing 5 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

Powershell should have a method. It's not really something that you'd do within a database.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

jonathanm 4432 SSChasing Mays Points: 619 More actions · Answer 2

Never used powershell. Is it something that is easily learned and can be done?

djj SSCoach Points: 18831 More actions · Answer 3

Powershell is not too bad to learn, as I managed to do some with it.:-)

As indicated file movement is not something a database is designed for so the Powershell would be one way of doing it.

amurjani SSC Eights! Points: 872 More actions · Answer 4

amurjani

SSC Eights!

Points: 872

July 21, 2015 at 8:03 am

#1813854

SSIS is another way

Alan Burstein SSC Guru Points: 61152 More actions · Answer 5

jonathanm 4432 (7/21/2015)
Never used powershell. Is it something that is easily learned and can be done?

Check out Stairway to Powershell[/url]

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001