Saturday, July 13, 2013

[SQL 2012] Can't find options to retain partitions in SSAS Tabular Deployment?

[SQL 2012] Can't find options to retain partitions in SSAS Tabular Deployment?

Can't find options to retain partitions in SSAS Tabular Deployment?

Posted: 04 Mar 2013 11:05 AM PST

So I have created a new Tabular cube on 2012, deployed it for a while. And created a few new partitions via SSMS in the server to cover all the data. Now I have made some changes in the project, planning to deploy it to the server, but can NOT find an option to ignore existing partitions (that are not defined in the project itself) I have tried it on a test db, and no matter what i do... the project seems to deploy its definition, and overwrite what's on the server. meaning all the partitions that i created after deploy are WIPED! I have billions of rows of data, so reprocessing all the missing partitions are really not preferable... and managing the partitions in project but not in ssms is also not preferable as we typicall use scripts to add / manage partitions after it goes livewe have found some blog posts about changing .deploymentoptions file... but we don't know what value we should change to (not in BOL).. we changed it to "RetainPartitions" as a test.. but that doesn't workanyone has been through this? thanks

Loading Infobright with SSIS in SQL Server 2012

Posted: 12 Jul 2013 07:54 AM PDT

I am playing around with Infobright but am having some problems with populating it using SSIS.Infobright uses the MySQL 3.5.1 ODBC driver and to external applications appears as if it is MySQL.Using the ADO.NET Destination I can load data from SQL Server into Infobright provided the population mode is set to row-by-row rather than batch.Populating a column store database row by row is s...l...o...w.Has anyone else tried populating Infobright with SSIS and if so what did you do to get it to work in an acceptable manner?
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog