SQL Server 2000 To SQL Server 2005 Migration Questions and Answers

Recent IT Questions

1 - 6 of 6
<<PREVIOUS 1 NEXT>>

Migrate User & Permissions SQL 2000 to SQL XXXX

Hello, I need to a new windows server, but too install MS SQL Server 2005. Who know or have a code to do this job. Tank you so much.

asked by Njimenez

  5 pts.

How to migrate a database from SQL Server 2000 to SQL Server 2005

Can someone explain in detail how to migrate a database from SQL Server 2000 to SQL Server 2005, including which components need to be migrated?

View Answer   |  Mar 30 2009  6:22 PM GMT
SQL Server 2000, SQL Server 2005, SQL Server migration
asked by SQL Server Ask the Experts

  2445 pts.

Migrating data from a SQL Server 2005 database to SQL Server 2000

I am looking for advice on what technology to use to migrate data from a SQL Server 2005 database to SQL Server 2000. We are currently phasing out our old help desk ticketing system in SQL Server 2005 to a new ticketing system in SQL Server 2000. The tables in the databases are not identical...

View Answer   |  Jan 26 2009  7:52 PM GMT
SQL Server 2005, SQL Server migration, SQL Server 2000
asked by SQL Server Ask the Experts

  2445 pts.

Script to restore database permissions during a migration to SQL Server 2005

We are in the process of migrating from SQL Server 2000 to SQL Server 2005, and I'm searching for a script that can transfer and restore the database permissions of all accounts from SQL Server 2000 to SQL Server 2005. I used sp_help_revlog to restore the logins, but I still have to restore the...

asked by SQL Server Ask the Experts

  2445 pts.

Log shipping after upgrading to SQL Server 2005

I've upgraded our warm backup to SQL Server 2005 recently, but our log shipping is down. How can SQL Server 2005 be used with SQL Server 2000 log shipping?

View Answer   |  Nov 11 2008  7:06 PM GMT
SQL Server 2000, SQL Server 2005, Log Shipping
asked by SQL Server Ask the Experts

  2445 pts.

Migrating from SQL Server 2000 to SQL Server 2005 on DTS packages

Could someone help me with a SQL Server 2000 migration to SQL Server 2005 on DTS packages? I have a Dynamics GP integration that uses the DTS package, but I don't know SQL or DTS packages well enough.

View Answer   |  Oct 21 2008  7:57 PM GMT
SQL Server 2000, SQL Server 2005, SQL Server migration
asked by SQL Server Ask the Experts

  2445 pts.

1 - 6 of 6
<<PREVIOUS 1 NEXT>>