I am trying to move our Umbraco site to a new server, but there are a few things that make this particularly challenging. Before I spend too much more time trying to make this happen, I wanted to check here and see if what I'm trying to do is even feasible. I have reviewed the forums for similar questions, and from what I've read, I'm not optimistic.
The first problem is that I know almost nothing about SQL.
Second, both the current and new server are hosted on shared servers with medium trust only.
Third, there is a SQL Server version disparity: the site currently runs on SQL Server 2008R2. The new server only has SQL Server 2008 (no R2). We also have the option of using MySQL.
Knowing all this, does anyone have advice on how to migrate this server? From what I understand, I can't user Courier2 (no full trust). I have loaded the new database as a Linked Server in SQL Management Studio, but, again, I am an absolute novice and don't know how to write the queries that would sync the two databases. I even tried using a utility called DBSync, but it failed with errors that I do not understand.
So, short of hiring a database expert to do the conversion for me, is there any hope that I could make this move myself?
moving site to new server
I am trying to move our Umbraco site to a new server, but there are a few things that make this particularly challenging. Before I spend too much more time trying to make this happen, I wanted to check here and see if what I'm trying to do is even feasible. I have reviewed the forums for similar questions, and from what I've read, I'm not optimistic.
The first problem is that I know almost nothing about SQL.
Second, both the current and new server are hosted on shared servers with medium trust only.
Third, there is a SQL Server version disparity: the site currently runs on SQL Server 2008R2. The new server only has SQL Server 2008 (no R2). We also have the option of using MySQL.
Knowing all this, does anyone have advice on how to migrate this server? From what I understand, I can't user Courier2 (no full trust). I have loaded the new database as a Linked Server in SQL Management Studio, but, again, I am an absolute novice and don't know how to write the queries that would sync the two databases. I even tried using a utility called DBSync, but it failed with errors that I do not understand.
So, short of hiring a database expert to do the conversion for me, is there any hope that I could make this move myself?
Eric,
Simplest way I have found to copy an SQL Server database is to do the following:
is working on a reply...