项目作者: DHJayasinghe
项目描述 :
MS SQL server data migration scripts
高级语言: TSQL
项目地址: git://github.com/DHJayasinghe/mssql-data-migrations.git
SQL-Data-Migrations
MS SQL server data migration scripts
- BLOB to PDF - Migrate BLOB pdf data saved in the Database to Filesystem while replacing the Target table PDF column with PDF file name.
- BLOB to JPEG - Migrate BLOB jpeg data saved in the Database to Filesystem while replace the Target table JPEG column with JPEG file name.
- Clean Customer DB - Clean customer database with single address line while identifying and separating single line address into multiple fields as building, street and city. This includes deletion of duplicate address entries and re-arranging foreign key relationships of data after removal.