Populating SQL Server database ADMIN schema

Go to Admin -> Data Centre -> Application Updates section and click the "Dump special Admin schema table data to .csv files" link. Extract the files to the appropriate directory accessible by MS SQL Server.

Use the following BULK INSERT statement for APPUPDATE, DISTRICT, FIELD_ENUMERATION, FLOW, FORM, FORM_DOMAIN, FORM_FIELD, FORM_TYPE,  PAGE_ITEM, RULE_DEFINITION, and SEX.Modify the table name, file name, and path.

BULK INSERT ADMIN.APPUPDATE
    FROM 'C:\tcc\updates\current\APPUPDATE.csv'
    WITH
    (
        KEEPIDENTITY,
    	FIELDTERMINATOR = '~',
        ROWTERMINATOR = '\n' ,
        DATAFILETYPE='char'
    ) 

The KEEPIDENTITY keyword enables the population of identity fields from the BULK INSERT command.