Categories

Scripting SQL Server Database Data

There have been many times when I've needed to script the creation of SQL Server database data; usually for source control management of core data that, in a given application, is relatively static and needs to be there at install time. It has also been useful for re-creation of test data. But how to create such

Filed under: Database,SQL | On : 2007 Jan 24 | From: A British Geek in Texas Pontificates |

What's New in ADO.NET 2.0 - New DataTable Features

SYSK 273: How to use the latest version of Visual Studio and build your project targeting earlier version of .NET framework

Similar Posts

Recipe: Deploying a SQL Database to a Remote Hosting Environment (Part 1)

Scenario You finish building a great ASP.NET application, have everything tested and working right on your local system, are taking full advantage of the

Tip/Trick: How to upload a .SQL file to a Hoster and Execute it to Deploy a SQL Database

Last month I posted about the new (free) Database Publishing Wizard that is designed to make it much, much easier to upload and deploy SQL Express and

SQL Server 2005 - scripting your database for moving to your hoster - Hosting Toolkit

SQL Server 2005I've written before about how to ease the challenge of scripting your data to move it from a local SQL Server 2005 .mdf database to a hoster

[SQL] Some of my favorite INFORMATION_SCHEMA utility queries

Phil just posted about using INFORMATION_SCHEMA to bulletproof your SQL change scripts . I've been working up a post on using queries against INFORMATION_SCHEMA

Most Popular

How To Group ListView Items with ListViewGroup VB2005

Publishing Reporting Services reports to MOSS

How to bind Generic Dictionary with dropdown list

Parse Comma Delimited TextFile with Visual Basic 2005 TextFieldParser

Using the Active Directory Membership Provider with Forms Authentication in MOSS 2007

Using a parameterized SSIS package as a data source for SQL Reporting Services