Showing posts from December, 2009

Migrating Database from MSSQL 2008 to 2005

If you go googleing around, you'll probably find, "impossible" cannot backward compatible, and damn a lot for migrating 05 to 08 and 00 to 05. Fsck google.

Here's how i do it.

From the mssql 2008, right click on the databse, Task > Generate Script..

You'll come to a wizard. Select your database. next. at the options selection page, make sure you choose two vital option, 1) migrate type to MSSQL 2005, 2) Data Script .

Next. selct all. select all. paceroh. then while it creating trhe sql statements, there might be errors. Why? because usually some data types in 2008 nt exist in 2005. so what u do? adjust a where applicable.. -____-"

Then, try generate sql again. setel.

next, just create a db in 2005. execute the script. done. and you'll vbe oine hepi chaild. :D

P/s: sory, no screenshots. lazy. And Kudos to Ewe fr the data script part. Tahnx.