I'm working with sharepoint 2013 and was asked to find some data from the site collections. I have a list of site collection names stored in a table in database but my manager asked to use a CSV file instead. I'm trying to find out the pros and cons. Is
there a distinct disadvantage of using SQL vs CSV file?
The only difference is portability. A Csv can be used without a server. A DB is more stable and easier to maintain. The issue is a design issue that can only be decided between you and your manager.