SSISDB catalog
deploy an SSIS project into SSISDB (3 ways)
data tools - BIDS ( in early version)
DTS (in earlier version) --> SSIS (08 or later version) (tasks/import or export...)
connection type (OLE DB, ODBC)
staging table
Hibernate insert
bulk insert with bulkadmin
con:
popular in legacy system, SP's logic is still on DB itself.
SP increases the difficulty of deployment and maintenance, causes higer coupling. It is not suitable for agile stystem development.
ORM (Object-Relational Mapping), converting data between incompatible type systems
Hibernate ORM
NHibernate
ADO.NET
LINQ
MVC
crystal report for .net -- bank
lync
Sharepoint
Onedrive
Skydrive
Google Doc
