Advantages of Saving to Files:
- Easier to do shared source control
- Ultra secure when using the Encrypt with User Key encryption option
- Not subject to network downtime problems (saved locally)
- May escrow deployment bundles including miscellaneous files
- Less steps to load into the designer
- Easier direct access for viewing
- May store packages hierarchically in file system
- Projects in Visual Studio are disk based and require the package to be in the file system
- Generally, a better experience during development
Advantages of Saving to SQL Server:
- Easier access by multiple individuals
- Benefits of database security, DTS roles and Agent interaction
- Packages get backed up with normal DB backup processes
- Able to filter packages via queries
- May store packages hierarchically via new package folders
- Generally, a better in-production experience
No comments:
Post a Comment