Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Data Portability

By Steve Jones,

It seems that there is a never ending list of formats that data professionals need to deal with. As I read through posts and articles talking about Integration Services, I'm struck by how many unique solutions people come up with to move data in and out of Excel. They know how to handle multiple worksheets, headers, practically anything that people put into Excel. If there's a pattern in there, chances are some SSIS worker has a solution.

This week I saw that Facebook had announced a data portability initiative, giving users the ability to download all their Facebook data into one file. The file can include images, movies, posts, events, etc. and gives you a way to not only back up your data, but perhaps use it for other applications. I'm sure it's only a matter of time before we have an SSIS package that can load up your information into a SQL Server database. I suspect someone will do it just for the challenge, and not because they have a practical use for it.

Facebook seems to have been under attack constantly from groups that are concerned about the privacy policies and features of a company that has so much data about individuals. However this new feature seems to show that the company isn't looking to lock you and your data into their own system. You can now backup your data and shut down your account if you with to move on to another service.

Recognizing that data is important to users and allowing some level of portability is a feature that I wish more companies would embrace. I'd love to be able to easily move my medical records, my financial investment history, or even my credit data to my own systems as a backup. Or even as a way to document the current state and perhaps ensure that my data is correct.

Steve Jones

Total article views: 104 | Views in the last 30 days: 1
Related Articles

Company Rewards

Is there something that your company could do for you that would show that they valued your employme...


March #Meme15 Round-up – Facebook

Are you ready for the round-up of last week’s #meme15 Facebook question? In total, there were eight...


#Meme15: On Facebook

This will be my first Meme15 (here’s Jason Strate’s original Meme15 post), and today we’re talking F...


Be Careful of Facebook

Even the President thinks so! In his talk yesterday, he warned kids about Facebook, and being carefu...


Why an employer should never ask about accessing your Facebook page

There's a brilliant piece of work posted as a fictitious resignation letter that gives some scenario...

database weekly    

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones