Umbraco Export Tool

Source code checked in

mrshrinkray — Thu, 31 Jan 2008 16:16:15 GMT

Upgrade to VS2008

Source code checked in

mrshrinkray — Tue, 05 Dec 2006 23:07:01 GMT

Changed from UTF-8 to UTF-16 (Unicode). Fixed bug with NULLs being scripted as '' (which meant datetimes were coming at as 1900 dates).

UPDATED WIKI: Home

mrshrinkray — Mon, 04 Dec 2006 19:34:05 GMT

About
This tool is for backing up your http://www.codeplex.com/umbraco database.

The tool was written for people who use shared hosting and don't have the luxury of being able to backup the database when they want, or install SSIS packages. The tool replaces the SQL Enterprise Manager/SQL Server Management Studio export (which doesn't copy keys/constraints anyhow) and is written specifically for Umbraco database objects.

This tool is intended to be used by people who know about connection strings and how to SQL Enterprise Manager/Management Studio, and have a basic understanding of the workings of SQL Server.

Getting started
The tool is simple to use. It grabs the data from your remote SQL Server, and writes out 3 SQL Scripts:

Step1.sql - This drops and creates all umbraco objects
Step2.sql - This contains all your data
Step3.sql - This creates all the database keys.

You need to run the SQL scripts inside Query Analyser (SQL Server 2000) or Management Studio (2005) in that order.

The export tool includes the option to ignore the log tables (which can often be very bulky) and also write out each of your tables to seperate files. This is useful if you only want to grab data from one particular table.

You can also set the dateformat if your server is running on a different Locale to your workstation. For example, setting it to dmy gives the UK time format.

Required downloads

SQL Server Management Studio
http://msdn.microsoft.com/vstudio/express/sql/download/

.NET 2 Framework
http://www.microsoft.com/downloads/details.aspx?FamilyID=0856eacb-4362-4b0d-8edd-aab15c5e04f5&displaylang=en

UPDATED WIKI: Home

mrshrinkray — Mon, 04 Dec 2006 19:33:34 GMT

Step1.sql - This drops and creates all umbraco objects
Step2.sql - This contains all your data
Step3.sql - This creates all the database keys.

CREATED WIKI: http://www.codeplex.com/umbraco

mrshrinkray — Mon, 04 Dec 2006 19:33:34 GMT

UPDATED WIKI: Home

mrshrinkray — Sat, 02 Dec 2006 14:46:59 GMT

Step1.sql - This drops and creates all umbraco objects
Step2.sql - This contains all your data
Step3.sql - This creates all the database keys.

UPDATED WIKI: Home

mrshrinkray — Sat, 02 Dec 2006 13:52:28 GMT

Step1.sql - This drops and creates all umbraco objects
Step2.sql - This contains all your data
Step3.sql - This creates all the database keys.

You need to run the SQL scripts inside Query Analyser (SQL Server 2000) or Management Studio (2005) in that order.

The export tool includes the option to ignore the log tables (which can often be very bulky) and also write out each of your tables to seperate files. This is useful if you only want to grab data from one particular table.

You can also set the dateformat if your server is running on a different Locale to your workstation. For example, setting it to dmy gives the UK time format.

Required downloads

SQL Server Management Studio
[url:http://msdn.microsoft.com/vstudio/express/sql/download/

.NET 2 Framework
http://www.microsoft.com/downloads/details.aspx?FamilyID=0856eacb-4362-4b0d-8edd-aab15c5e04f5&displaylang=en

UPDATED WIKI: Home

mrshrinkray — Sat, 02 Dec 2006 13:51:37 GMT

About
The tool was written for people who use shared hosting and don't have the luxury of being able to backup the database when they want, or install SSIS packages. The tool replaces the SQL Enterprise Manager/SQL Server Management Studio export (which doesn't copy keys/constraints anyhow) and is written specifically for Umbraco database objects.

This tool is intended to be used by people who know about connection strings and how to SQL Enterprise Manager/Management Studio, and have a basic understanding of the workings of SQL Server.

Getting started
The tool is simple to use. It grabs the data from your remote SQL Server, and writes out 3 SQL Scripts:

*Step1.sql - This drops and creates all umbraco objects
*Step2.sql - This contains all your data
*Step3.sql - This creates all the database keys.

You need to run the SQL scripts inside Query Analyser (SQL Server 2000) or Management Studio (2005) in that order.

The export tool includes the option to ignore the log tables (which can often be very bulky) and also write out each of your tables to seperate files. This is useful if you only want to grab data from one particular table.

You can also set the dateformat if your server is running on a different Locale to your workstation. For example, setting it to dmy gives the UK time format.

Required downloads

SQL Server Management Studio
[url:http://msdn.microsoft.com/vstudio/express/sql/download/

.NET 2 Framework
http://www.microsoft.com/downloads/details.aspx?FamilyID=0856eacb-4362-4b0d-8edd-aab15c5e04f5&displaylang=en

UPDATED WIKI: Home

mrshrinkray — Sat, 02 Dec 2006 13:50:05 GMT

About
The tool was written for people who use shared hosting and don't have the luxury of being able to backup the database when they want, or install SSIS packages. The tool replaces the SQL Enterprise Manager/SQL Server Management Studio export (which doesn't copy keys/constraints anyhow) and is written specifically for Umbraco database objects.

This tool is intended to be used by people who know about connection strings and how to SQL Enterprise Manager/Management Studio, and have a basic understanding of the workings of SQL Server.

It's a simple to use utility that grabs the data from your remote server, and writes out 3 SQL Scripts:

*Step1.sql - This drops and creates all umbraco objects
*Step2.sql - This contains all your data
*Step3.sql - This creates all the database keys.

You need to run the SQL scripts inside Query Analyser (SQL Server 2000) or Management Studio (2005) in that order.

The export tool includes the option to ignore the log tables (which can often be very bulky) and also write out each of your tables to seperate files. This is useful if you only want to grab data from one particular table.

You can also set the dateformat if your server is running on a different Locale to your workstation. For example, setting it to dmy gives the UK time format.

Required downloads

http://msdn.microsoft.com/vstudio/express/sql/download/SQL Server Management Studio
http://www.microsoft.com/downloads/details.aspx?FamilyID=0856eacb-4362-4b0d-8edd-aab15c5e04f5&displaylang=en .NET 2 Framework

CREATED RELEASE: 1 Production

Sat, 02 Dec 2006 13:25:30 GMT

Version 1

UPDATED RELEASE: 1 Production

Fri, 01 Dec 2006 08:00:00 GMT

Version 1

UPDATED RELEASE: 1 Release Candidate

Fri, 01 Dec 2006 08:00:00 GMT

Version 1