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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Sharepoint Server 2007 and SQL Server 2005

Author  Topic 

moss2007
Starting Member

2 Posts

Posted - 2007-12-06 : 11:40:03
Hi all (and sorry for crossposting)!
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.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-12-06 : 13:32:01
duplicate:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=93811

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com
Go to Top of Page
   

- Advertisement -