SAP Note 1593998 - SMIGR_CREATE_DDL for MSSQL

Component : Microsoft SQL Server -

Solution : https://service.sap.com/sap/support/notes/1593998 (SAP Service marketplace login required)

Summary :
This SAP Note outlines the new system copy report SMIGR_CREATE_DDL implementation for Microsoft SQL Server. The update, thus far, has been rolled out in two phases. Wave 1 covers initial shipping including support for SAP NetWeaver 7.30 and 7.31/7.03 across various support package stacks. Wave 2 involves downports and enhancements extending support back to NetWeaver versions as early as 7.00 through 7.31. Enhancements include SQL Server 2012 support and the ability to parallelize DDL generation via asynchronous RFC. The note also clarifies prerequisites, updates execution guidelines for the report, and provides specific configurations for indexed and non-indexed BW table types.

Key words :
tabname = '&global_property'indexname = ''useflag = 'x'posnr = 1, nsign = 'i'parname = 'smigr_parallelism'text = 10in, sql server target release supports maximal 1000 partitions, 0----------------------------------------------------ddl statements generated successfullythe output means, individual bw table types handled, option exports relevant bw tables, cube e-fact tables [/bi /, cube f-fact tables [/bi /, sql server 2005 supports maximal 1000 partitions, sql server target release option

Related Notes :

1471910SQL Server Partitioning in System Copies and DB Migrations
888210NW 7.**: System copy (supplementary note)