SyncData for SQL Server

  •        48

Synchronizes the data contained in two or more database tables with the same structure, generating insert, update and delete instructions that allows that the target and source table have the same data.



Related Projects

SQL Database script generation for Visual Studio 2008

This project host a Visual Studio Add-In for creating schema scripts, stored procedures and views from SQL Server. Basically, with a couple of clicks you can generate all your tables, stored procedures, and views as individual scripts with DROP/Add statements for foreign keys...

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.

BIDS Helper

A Visual Studio add-in with features that extend and enhance business intelligence development functionality in SQL Server 2005, 2008, and 2008 R2 BI Development Studio (BIDS) and SQL Server 2012 SQL Server Data Tools (SSDT).

SQL Compact data and schema script utility

This console app and SQL Server 2008 Management Studio add-in helps you better manage your SQL Compact development efforts. It allows you to script schema and data to a .sql file, which can be used in any context. It also scripts DML for use in SSMS scripts.

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...

SQL Compact Command Line Tool

Administer SQL Compact databases directly from the command line, without having Visual Studio or SQL Server Management Studio installed. Only requires NetFx 2.0 and SQL Compact installed. Command line options similar to sqlcmd. Also runs any SQL Compact script files.

SQL Server Compact Toolbox

SQL Server Compact Toolbox is a Visual Studio add-in and standalone app , for managing all aspects of your SQL Server Compact database files

Azure Table Sync Lib

Developing custom sync providers for Windows Azure Table Storage to support the following sync scenarios 1. Azure Table <-> SQL Server 2. Azure Table <-> SQL CE 3. Azure Table <-> SQL Azure

Visual Foxpro to SQL Server table replication

Create a method for a periodic import and merge of data from a FoxPro Database Linked Server in SQL 2008 to a new Database in SQL 2008. The changes will only occur in the FoxPro Tables, the SQL Database just needs to be a replicated copy with periodic updates.

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.

GraphView - GraphView is a DLL library that enables users to use SQL Server or Azure SQL Database to efficiently manage graphs

GraphView is a DLL library that enables users to use SQL Server or Azure SQL Database to manage graphs. It connects to a SQL database locally or in the cloud, stores graph data in tables and queries graphs through a SQL-extended language. It is not an independent database, but a middleware that accepts graph operations and translates them to T-SQL executed in SQL Server or Azure SQL Database. As such, GraphView can be viewed as a special connector to SQL Server/Azure SQL Database. Developers will experience no differences than the default SQL connector provided by the .NET framework (i.e., SqlConnection), only except that this new connector accepts graph-oriented statements.GraphView is a DLL library through which you manage graph data in SQL Server (version 2008 and onward) and Azure SQL Database (v12 and onward). It provides features a standard graph database is expected to have. In addition, since GraphView relies on SQL databases, it inherits many features in the relational world that are often missing in native graph databases.

LearnAnalytics-SQLServerRServices - A one day instructor-led course showcasing the SQL Server R Services architecture and best practices

Welcome to the SQL Server R Services Repository. You can find the latest materials from the workshop here. This course is intended for data scientists and SQL analysts interested in the R Services feature that was released with SQL Server 2016. We review the two common architectures that R and SQL Server use to communicate with each other. We see how we can do in-database analytics directly from our favorite R IDE (Visual Studio with RTVS or RStudio). We see how Microsoft R's RevoScaleR package can help us scale the analytics when the data is large. We examine different use cases and in the process of implementing them we learn about some best practices to follow to take full advantage of both SQL Server and R.You will find all the rendered course content in student_resources. If you wish to run the code you can open the Rmd files in instructor_resources in your R IDE.

SQL-Server-R-Services-Samples - Advanced analytics samples and templates using SQL Server R Services

In these examples, we will demonstrate how to develop and deploy end-to-end advanced analytics solutions with SQL Server 2016 R Services.Develop models in R IDE. SQL Server 2016 R services allows Data Scientists to develop solutions in an R IDE (such as RStudio, Visual Studio R Tools) with Open Source R or Microsoft R Server, using data residing in SQL Server, and computing done in-database.

Data Dictionary Creator

Data Dictionary Creator (DDC) is a simple application which helps you document SQL Server databases. It stores all the information in Extended Properties, so it's easier to keep the documentation in sync with the database as it changes.

SQL Server Management Studio (SSMS) AddIn to automatically name SQL windows

This project extends SQL Server Management Studio (2005, 2008 and 2008R2) by automatically naming SQL windows - no more searching through hundreds of untitled windows looking for the one you want, and no more having hundreds of windows open. Also auto-saves all SQL.

SQL Compact Code Generator

Contains a stand alone GUI application and a Visual Studio Custom Tool for automatically generating a .NET data access layer code for objects in a SQL Server Compact Edition database.

SQL Load Test

This tool takes a SQL Profiler trace file and generates a unit test that replays the same sequence of database calls found in the trace file. The unit test is designed for Visual Studio Load Test. The code generated is easily modifiable so that data variation can be included.

O Library

O Library is a SQL 2008/2012 Framework that enables developer to add a .Net feeling to their T-SQL code and aims to bring a bit of fun into T-SQL development.