Step by Step duplicate an existing umbraco - Installing

umbraco Forum » Installing » Installing » Step by Step duplicate an existing umbraco

Step by Step duplicate an existing umbraco

Options

Previous Topic · Next Topic

thahammer

Posted: Friday, May 09, 2008 11:49:07 AM

Rank: Aficionado

Joined: 8/28/2007
Posts: 121
Location: Bavaria

Did anyone have an Step by Step instruction to Do this?

I don´t get it. Boys i´m coming from php and Mysql, and i tell you all. I never had so much problems with moving an Database! The Last Time i did that in mysql it was done and working after 5 Minutes. Liar

So i found out, that there are a few really stupid Problems when moving an SQL Database.

- Sometimes the DB Owner is changed (Why)
- the Primary Key and the Auto increment are not copied (Not always but often)

This two things i found out right now. I make the next Test Today with an completly new DB and Umbraco Copy.

Please have someone an Step by Step instruction for that?? I need it urgently for Customers.

I Love umbraco

imayat12

Posted: Friday, May 09, 2008 3:40:09 PM

Rank: Fanatic

Joined: 7/19/2006
Posts: 416
Location: Preston, UK

Coming from mysql background you would be more comfortable with exporting out whole db with data as csv.

Something that may help in the sql server world is Database publishing wizard on your target server create your db and same user account. Then using the publishing wizard you can publish out sql script for the whole db including content (the file can get a bit big) then you run the script on your target.

Its got me out of a few holes.

Regards

Ismail

Level 2 certified. If it aint broke dont fix.

Prle

Posted: Sunday, May 11, 2008 4:56:44 AM

Rank: Newbie

Joined: 6/29/2007
Posts: 16
Location: Zagreb, Croatia

Hi

you can change db owner back to what you need (dbo) using sp_changeobjectowner stored procedure.

I never had a problem with Primary Key and the Auto increment not copied so i can't help you with that.

drobar

Posted: Sunday, May 11, 2008 2:29:53 PM

Rank: Umbracoholic

Joined: 9/8/2006
Posts: 1,084
Location: KY, USA

Casey has a little sql script to change the owner of a database if you need it. There's a link in this thread http://forum.umbraco.org/yaf_postsm23372_Duplicate-my-existing-umbraco.aspx#23372

cheers,
doug.

MVP 2007/2008 - Official Umbraco Trainer for North America - Percipient Studios

VirtualRichard

Posted: Monday, May 12, 2008 11:13:35 AM

Rank: Aficionado

Joined: 9/17/2007
Posts: 119
Location: London, UK.

I use the SQL Server Database Publishing Wizard.

The words 'sledghammer' and 'nut' spring to mind but I have moved the database dozens of times with little effort using this little tool. Just make sure the two servers are set up the same.

2 * 3 * 3 * 37 : The prime factorisation of The Beast.

thahammer

Posted: Wednesday, May 14, 2008 12:58:21 PM

Rank: Aficionado

Joined: 8/28/2007
Posts: 121
Location: Bavaria

i Have 2 SQL Servers. The old one is an SQL2000 Server and the new one is an SQL2005 Server. I installed the Tool on both Servers, but if i wanna transfer an Database i get an Error from the Old Server.

I Love umbraco

Users browsing this topic

Guest

umbraco Forum » Installing » Installing » Step by Step duplicate an existing umbraco

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.