SQL Server Partition Management

  •        72

Managing SQL Server Table partitions requires creating staging tables with indexes and constraints that match a specific partition of a permanent table. This utility creates staging tables on-demand, eliminating the need modify scripts when table or index structures change.

http://sqlpartitionmgmt.codeplex.com/

Tags
Implementation
License
Platform

   




Related Projects

ExportSQLScript - Export MS SQL 2008R2/2008/2005/2000 objects to script


Command line driven utility to export MS SQL objects to script files suitable for database creation and revision control. Uses 2008R2 Server Management Objects (SMO) which are compatible with SQL Server 2000, SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.

Free SQL Server Database Templates & SQL Code Download


You can download here SQL Server Database Templates an SQL Source codes for various type of projects, Template Downloads for SQL Server

Sql 2005 DataBase Helper


This is a helper class to use Sql server 2005. 1. Simplifies connection 2. Reading data, querying the database 3.Updating data to the database 4. Get data in form of Datasets, DataTable, Datareader etc Vs2005 and C# .Net 2.0

SQL 2005 Service Manager


Welcome to the SQL 2005 Service Manager project. SQL 2005 Service Manager is a replacement for the SQL Server Service Manager that came with SQL Server 2000 but is no longer shipped as part of SQL Server. It allows the management and monitoring of all local SQL Server related ...



VisualDB (Database Management using Visual WebGui)


VisualDB is a Database Management created using Visual WebGui and actually support SQL Server 2000-2005 and MySQL 5.

Standalone SQL Agent


The Standalone SQL Agent provides SQL Express users with the ability to use the SQL Server Agent features of the database system even though Microsoft has decided to remove the SQL Agent from the SQL Express product. This project is developed using Visual Basic.NET 2008.

Coolstorage - ORM library for .NET


The main strength of Vici CoolStorage is the ease of use. Most ORM tools still require a lot of unneeded code to accomplish basic data persistence tasks, but Vici CoolStorage is designed to relieve the programmer from these tedious and error-prone tasks, making it very intuitive to use.

DbDiff: Database Diff and Database Scripting


Compare MSSql database structures. (Sql 2005, Sql 2008, Sql 2008R2, Sql Denali ) Features: - compare database structures - scripting without dmo or smo - commandline scripting, commandline compare - standalone dll-s for referencing

SqlHarvester Database Scripting Engine


SqlHarvester is a free command-line based scripting engine written in .Net. It enables the import/export of database content across disconnected Sql Server databases.

SQL Server Replication Explorer


SQL Server Replication Explorer is a client tool for browsing through Microsoft SQL Server replication topology. It can also be used for troubleshooting and monitoring of the Microsoft SQL Server replication.

Allocation SQL Server Management Studio Add-in


This is add-in for SQL Server Management Studio (SSMS) to display database allocation information. It builds on allocation information displayed by SQL Internals Viewer to show how data is allocated in SQL Server files. The add-in also displays information on space usage, ta...

Index Analysis


Index Analysis allows DBAs and developers to analyze the indexes in a database to determine the use, characteristics, and statistics of the index. The project contains the query written in T-SQL and report that can be opened as a custom report in SSMS.

SQL Database Migration Wizard v3.9.12 & v4.0.15


SQL Database Migration Wizard (SQLAzureMW) is designed to help you migrate your SQL Server 2005/2008/2012 databases to Azure SQL Database.

ScriptDB


ScriptDb is a simple console app written in C# that uses SQL Management Objects (SMO) to script all the objects in a database. It will work against any SQL Server 2000 or 2005 database. It creates a directory tree structure with a similar hierarchy to that in Object Explorer i...

FileSystemHelper SQL Server CLR


FileSystemHelper SQL Server CLR provides a collection of CLR stored procedures and functions for interacting with the file system. Using these stored procedures and functions will allow you to avoid enabling xp_cmdshell on your SQL Server instances.

Fulltext Management for SQL Server (Express)


This Addin for SQL Server Management Studio allows you to manage your fulltext catalogs easily. It even works for SQL Server Express editions, so now you can use a nice GUI instead of unhandy SQL commands.

sqlperms - A tool for calculating necessary SQL Server permissions


SqlPermissions is a tool used to calculate the precise minimal permissions necessary for an application using a database. It works in an online fashion by monitoring active connections, or offline by using a sql trace; in both cases each trace event is used to determine a permission grant for every monitored statement. It currently is targeted to work against SQL Server 2012 and 2014, though should be backward compatible with most older SQL Server products after 2005. It does not work with other

Big SQL Script File Runner


Here's project that enables any developers or others to run the big sql script file greater than 300MB or any size. It also supports rollback feature & others.

Open DBDiff


Open DBDiff is an open source database schema comparison tool for SQL Server 2005/2008. It reports differences between two database schemas and provides a synchronization script to upgrade a database from one to the other.