On our corporate portal where our business processes are custom-programmed via an SQL database, we already capture metadata about new documentation projects - metadata such as project name, date due, authors, reviewers, and so forth. Our SQL database also contains all our document templates.
By what methodology can we programmatically pass these parameters to Sharepoint, so that a new Sharepoint document library can be automatically, programmatically, configured for each new document project, document templates uploaded into the library, team member permissions configured, due dates placed in the Sharepoint project calendar, etc, all without requiring a human to physically configure these things via the Sharepoint interface?
The purpose: use our legacy SQL system as a base, but seamlessly hop over to Sharepoint whenever document management, version control, check out/in, etc. is required, using Sharepoint as a kind of 'solution module' as needed.
