Can I restore a SQL 2000 backup to a new SQL Server 2005?
Can I restore a SQL 2000 backup to my new SQL Server 2005? Will I have to perform any other steps or can I do a simple backup and restore? Windows 2008 Server.

Answer Question   |  September 8, 2010  8:32 PM
SQL 2000, SQL migration, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server backup, SQL Server migration, Windows Server 2008

Importing large sets of Excel 2000 data to SQL database
I have large data sets of over 5 million customers in several excel 2000 worksheets. I would like to import the data to a SQL database and preserve all data including notes fields which are huge and contain all types of characters. What is the best method of achieving this?

Answer Question   |  August 18, 2010  8:08 PM
Data migration, Excel 2000, Excel Database, Excel worksheets, SQL Database, SQL migration

Converting from RPGLE to DB2/400 SQL
My shop just announced that it intends to convert from RPGLE on the ISeries 400 platform, to SQL, such that the procedures will be portable to other hardware platforms. What documentation to I need to acquire to train on writing SQL procedures; initially within DB2/400?

Answer Question   |  June 22, 2010  8:30 PM
DB2/400, RPGLE, SQL, SQL migration

How do I confirm all the data moved from Source to target for different tables
How do I confirm all the data moved from Source to target for different tables. I am not able to phrase this question. Bottom line I want to make sure all the data was transferred to target database. That is my test to validate. Thanks

Answer Question   |  November 25, 2009  4:35 PM
Data migration, SQL, SQL migration

SQL 2005 Password
If you move a sql 2000 database to sql 2005 which admin password does it have now.

Answer Question   |  June 6, 2009  3:12 PM
SQL 2000, SQL 2000 to 2005 Migration, SQL 2005, SQL Database, SQL migration, SQL passwords