-
Notifications
You must be signed in to change notification settings - Fork 5
/
sampleConfig.txt
51 lines (48 loc) · 2.9 KB
/
sampleConfig.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
// *******************
// WorldWideImporters
// var tableNameToCollectionMapping = new Dictionary<string, string>
// {
// {"Application_StateProvinces_Archive", "Application_StateProv_Arch"},
// {"Warehouse_StockItemTransactions", "Warehouse_StockItemTrans"},
// {"Warehouse_ColdRoomTemperatures_Archive", "Warehouse_ColdRoomTemp_Arch"},
// {"Application_DeliveryMethods_Archive", "Application_DeliveryMeth_Arch"},
// {"Purchasing_SupplierTransactions", "Purchasing_SupplierTrans"},
// {"Application_PaymentMethods_Archive", "Application_PaymentMeth_Arch"},
// {"Application_TransactionTypes_Archive", "Application_TransTypes_Arch"},
// {"Purchasing_SupplierCategories_Archive", "Purchasing_SupplierCat_Arch"},
// {"Sales_CustomerCategories_Archive", "Sales_CustomerCategories_Arch"},
// };
// *******************
// *******************
// AdventureWorks
// UseSchemaForScope = false
// var tableNameToCollectionMapping = new Dictionary<string, string>
// {
// {"Production_ProductListPriceHistory", "Production_ProductListPrHist"},
// {"Production_ProductModelIllustration", "Production_ProductModelIllus"},
// {"Production_ProductModelProductDescriptionCulture", "Production_ProdMoProdDesCult"},
// {"Production_TransactionHistoryArchive", "Production_TransactHisArch"},
// {"HumanResources_EmployeeDepartmentHistory", "HumanResources_EmpDeptHist"},
// {"HumanResources_EmployeePayHistory", "HumanResources_EmpPayHistory"},
// {"Sales_SalesOrderHeaderSalesReason", "Sales_SalesOrderHeadSalRea"}
// };
// UseSchemaForScope = true
// var tableNameToCollectionMapping = new Dictionary<string, string>
// {
// {"ProductModelProductDescriptionCulture", "ProductModelProductDescCult"}
// };
// *******************
// setup config object for SqlToCb
// var migrateConfig = new SqlToCbConfig
// {
// SourceSqlConnectionString = "Server=localhost;Database=AdventureWorks2016;Trusted_Connection=True;",
// TargetBucket = "AdventureWorks2016",
// TargetBucketRamQuotaMB = 1024,
// TargetConnectionString = "couchbase://localhost",
// TargetPassword = "password",
// TargetUsername = "Administrator",
// TableNameToCollectionMapping = tableNameToCollectionMapping,
// UseSchemaForScope = false,
// UseDefaultScopeForDboSchema = true,
// DefaultPasswordForUsers = "Change*This*Password*123"
// };