I tried the sql server Migration assistant and I have got good results , it is an easy way to transfer data and also stored procedure.