正文

SSISDB

(2014-07-22 21:30:01) 下一個
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





[ 打印 ]
閱讀 ()評論 (0)
評論
目前還沒有任何評論
登錄後才可評論.