I'm currently running SQL Server 2014 and we have some tables that have been partitioned and I'm trying to use the
ManagePartition application here (http://sqlpartitionmgmt.codeplex.com/)
I've typed into the command line:
C:\>ManagePartition.exe /C:CreateStagingFull /d:<Databasename> /s:<schema> /t:<TableName> /p:5 /A:<NewTablename> /f:C:/scripts.sql /O:i /U:<My Login> /P:/<My Password>
And I'm getting the following error:
ConnectionFailureException: Failed to connect to server (local). ---> System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
I've doubled checked all the spellings (dbname, schema, table, etc...) and the switches.
What are some things I can do to trouble shoot this (I'm kind of new to table partitioning)?
Or are there other strategies to easily manage/move data from partitioned table to a staging table?
Edit(I missed to the /S: switch)
I'm now getting this error:
System.NullReferenceException: Object reference not set to an instance of an object.
at PartitionManagement.PartitionManager.createStgIndex(Index i, TableViewBase parent)
at PartitionManagement.PartitionManager.CreateStgIndexes(Boolean createNonClusteredIndexes)
at PartitionManagement.App.Run(AppArgs& parsedArgs)
Object reference not set to an instance of an object.
It did create the new table, with the indexes, constraints(including the partition constraint), but no data.