Migrating data from SQL Server 2000 to SQL Server 2005?

Although it would be an excellent exercise to use this as an opportunity to learn SSIS, I imagine real world deadline pressures will dictate that you're better off sticking with the tools you know (T-SQL, stored procs) rather than trying to learn something brand new, especially for a single use transformation like this.

You should be able to use the Data Import Wizard from SQL 2005 to import the data for you.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions