Migrating A SQL 7 DB to SQL 2005

We are planning on upgrading a SQL 7 Server to 2005 SP1. I ran the Update Advisor and one of the issues listed was that the Database Maintenance Plan would not work in Server 2005. The Advisor mentions a tool to use but not which one, which is my first question.

I went online and found some documentation regarding copying the database etc., however, when attempting to copy from the SQL 2000 (DB in SQL 7) to 2005 (I have SQL 2000 and 2005 on my machine) when I try and connect to the 2005 box, its listed as one of the instances but will not connect.

For grins and kicks I backed the database up in the 2000 environment and restored it on a test machine which is in 2005. The Advisor was correct, I am unable to create a Database Maintenance Plan, which I find odd. The Database shows up under the databases but will not show up in the list of db's to create a plan for. So, I attempted to create the jobs and alerts manually.

There has to be an easier way to do this, can anyone help?

Carolyn,
Try the Setup and Upgrade forum instead. You'll have better luck there.

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=95&SiteID=1|||Thread moved from SSIS forum...|||I figured out how to get around this issue. I copied the databases using the wizard in 2000 between sql 7 and 2000, than I migrated the sql 7 db's into 2000. Once the db's are in 2000, open the server management suite in 2005 create a move package and move the dbs into 2005. If the package is created in 2005, you can create a db maintenance plan. I had test servers set up in both the 2000 and 2005 environment so switching wasn't a hassle.

Migrate SQL 2000 to SQL 2005

We want to migrate some x64 servers from 32bit SQL 2000 to 64bit SQL 2005
I know that upgrading SQL 2000 to x64 SQL 2005 isn't possible and I expect
upgrading x32 SQL2005 to x64 SQL2005 isn't possible either.
I don't mind doing an un-install or SQL 2000 then a clean install of SQL
2005 x64 but my problem is a large number of SQL logins
Is there any easy way to export SQL logins and passwords from SQL2000 and
import them into SQL2005?
Thanks
Peter Lawton
Hi
This can be run on your SQL 2000 installation
http://support.microsoft.com/kb/2461...22120121120120
John
"Peter Lawton" <devnull@.fakedomain.com> wrote in message
news:uktsVlHCGHA.4040@.TK2MSFTNGP12.phx.gbl...
> We want to migrate some x64 servers from 32bit SQL 2000 to 64bit SQL 2005
> I know that upgrading SQL 2000 to x64 SQL 2005 isn't possible and I expect
> upgrading x32 SQL2005 to x64 SQL2005 isn't possible either.
> I don't mind doing an un-install or SQL 2000 then a clean install of SQL
> 2005 x64 but my problem is a large number of SQL logins
> Is there any easy way to export SQL logins and passwords from SQL2000 and
> import them into SQL2005?
> Thanks
> Peter Lawton
>
|||mant thanks - that looks like just what I need!
Peter Lawton
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:ehKcwoUCGHA.2908@.TK2MSFTNGP09.phx.gbl...
> Hi
> This can be run on your SQL 2000 installation
> http://support.microsoft.com/kb/2461...22120121120120
> John
> "Peter Lawton" <devnull@.fakedomain.com> wrote in message
> news:uktsVlHCGHA.4040@.TK2MSFTNGP12.phx.gbl...
>

Migrate SQL 2000 to SQL 2005

We want to migrate some x64 servers from 32bit SQL 2000 to 64bit SQL 2005
I know that upgrading SQL 2000 to x64 SQL 2005 isn't possible and I expect
upgrading x32 SQL2005 to x64 SQL2005 isn't possible either.
I don't mind doing an un-install or SQL 2000 then a clean install of SQL
2005 x64 but my problem is a large number of SQL logins
Is there any easy way to export SQL logins and passwords from SQL2000 and
import them into SQL2005?
Thanks
Peter LawtonHi
This can be run on your SQL 2000 installation
http://support.microsoft.com/kb/246133/#XSLTH3145121122120121120120
John
"Peter Lawton" <devnull@.fakedomain.com> wrote in message
news:uktsVlHCGHA.4040@.TK2MSFTNGP12.phx.gbl...
> We want to migrate some x64 servers from 32bit SQL 2000 to 64bit SQL 2005
> I know that upgrading SQL 2000 to x64 SQL 2005 isn't possible and I expect
> upgrading x32 SQL2005 to x64 SQL2005 isn't possible either.
> I don't mind doing an un-install or SQL 2000 then a clean install of SQL
> 2005 x64 but my problem is a large number of SQL logins
> Is there any easy way to export SQL logins and passwords from SQL2000 and
> import them into SQL2005?
> Thanks
> Peter Lawton
>|||mant thanks - that looks like just what I need!
Peter Lawton
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:ehKcwoUCGHA.2908@.TK2MSFTNGP09.phx.gbl...
> Hi
> This can be run on your SQL 2000 installation
> http://support.microsoft.com/kb/246133/#XSLTH3145121122120121120120
> John
> "Peter Lawton" <devnull@.fakedomain.com> wrote in message
> news:uktsVlHCGHA.4040@.TK2MSFTNGP12.phx.gbl...
>> We want to migrate some x64 servers from 32bit SQL 2000 to 64bit SQL 2005
>> I know that upgrading SQL 2000 to x64 SQL 2005 isn't possible and I
>> expect upgrading x32 SQL2005 to x64 SQL2005 isn't possible either.
>> I don't mind doing an un-install or SQL 2000 then a clean install of SQL
>> 2005 x64 but my problem is a large number of SQL logins
>> Is there any easy way to export SQL logins and passwords from SQL2000 and
>> import them into SQL2005?
>> Thanks
>> Peter Lawton
>

Migrate SQL 2000 to SQL 2005

We want to migrate some x64 servers from 32bit SQL 2000 to 64bit SQL 2005
I know that upgrading SQL 2000 to x64 SQL 2005 isn't possible and I expect
upgrading x32 SQL2005 to x64 SQL2005 isn't possible either.
I don't mind doing an un-install or SQL 2000 then a clean install of SQL
2005 x64 but my problem is a large number of SQL logins
Is there any easy way to export SQL logins and passwords from SQL2000 and
import them into SQL2005?
Thanks
Peter LawtonHi
This can be run on your SQL 2000 installation
http://support.microsoft.com/kb/246...122120121120120
John
"Peter Lawton" <devnull@.fakedomain.com> wrote in message
news:uktsVlHCGHA.4040@.TK2MSFTNGP12.phx.gbl...
> We want to migrate some x64 servers from 32bit SQL 2000 to 64bit SQL 2005
> I know that upgrading SQL 2000 to x64 SQL 2005 isn't possible and I expect
> upgrading x32 SQL2005 to x64 SQL2005 isn't possible either.
> I don't mind doing an un-install or SQL 2000 then a clean install of SQL
> 2005 x64 but my problem is a large number of SQL logins
> Is there any easy way to export SQL logins and passwords from SQL2000 and
> import them into SQL2005?
> Thanks
> Peter Lawton
>|||mant thanks - that looks like just what I need!
Peter Lawton
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:ehKcwoUCGHA.2908@.TK2MSFTNGP09.phx.gbl...
> Hi
> This can be run on your SQL 2000 installation
> http://support.microsoft.com/kb/246...122120121120120
> John
> "Peter Lawton" <devnull@.fakedomain.com> wrote in message
> news:uktsVlHCGHA.4040@.TK2MSFTNGP12.phx.gbl...
>

Migrate Reporting Services Databases

I am upgrading the server that houses the SQL Reporting Services
databases (RSwwebservice, IIS and Report Manager are on another box).
The new server will have the same name (fqdn) as the old one.
Any issue with simply backin up the SQL RS dbs and restoring them the
new new server?
Thanks!Make sure to backup & restore the encryption key!
See also:
*
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_dbadmin_v1_4915.asp
*
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_dbadmin_v1_98xh.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim" <emailjeffp@.yahoo.com> wrote in message
news:1106780668.274285.107650@.z14g2000cwz.googlegroups.com...
> I am upgrading the server that houses the SQL Reporting Services
> databases (RSwwebservice, IIS and Report Manager are on another box).
> The new server will have the same name (fqdn) as the old one.
> Any issue with simply backin up the SQL RS dbs and restoring them the
> new new server?
> Thanks!
>|||Thanks.
I am not moving the Reporting Services Front end (i.e IIS, Report
Manager, etc..) do I still need to backup/restore the encryption key?|||If you only move the backend database, but not the RS webservice it is not
required to backup and restore the encryption keys. Nonetheless, you should
always backup the keys right after installation of RS.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim" <emailjeffp@.yahoo.com> wrote in message
news:1106840440.083283.232730@.c13g2000cwb.googlegroups.com...
> Thanks.
> I am not moving the Reporting Services Front end (i.e IIS, Report
> Manager, etc..) do I still need to backup/restore the encryption key?
>|||I am having a similar problem - we currently have sql server reporting server
and sql server standard on the same machine. I have loaded the sql reporting
services onto a new machine that also has sql server running. All I want to
do is move the database from the old machine to the new machine - when i do
the backup and restore i see the folders and all my reports but I can not run
any of the reports - i have tried to reactivate using rsactivate and rsconfig
without success. Can I just use DTS to copy the data from the old sql server
database to the new?
"Jim" wrote:
> I am upgrading the server that houses the SQL Reporting Services
> databases (RSwwebservice, IIS and Report Manager are on another box).
> The new server will have the same name (fqdn) as the old one.
> Any issue with simply backin up the SQL RS dbs and restoring them the
> new new server?
> Thanks!
>sql