Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
moss2007
Starting Member
2 Posts |
 Posted - 2007-12-06 : 11:38:15
|
| Hi all!I'm VERY new to MOSS2007 and I have couple of questions about it and SQL Server 2005. The basic idea is to receive data from MOSS2007 into SQL Server 2005 in my own database and make some reports from there.Which are the best practices to receive data from MOSS2007 into SQL Server 2005? Do I have to write some dlls for example with VB.NET (and use Sharepoint API calls) and use those dlls in stored procedures in SQL Server 2005? Or can I just use normal T-SQL (I believe that data in MOSS2007 is saved in lists and lists are saved in DB)?Waiting for your replies. The more detail your answer is the more grateful I am!Thanks!Best Regards,Harry F. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-06 : 22:46:20
|
| Does SS store docs in sql db? Why copy data to your own db? |
 |
|
|
|
|
|
Sharepoint Server 2007 and SQL Server 2005