I"m trying to export a databse from my express 2005 to 2000 and I tried using managment studio and doesn't seem to work.
Can anybody give me some tips or links that teach me how to do that? I googled around , so far, havne't found a good solution yet.
Thanks
Hi,
How did you perform the exporting? And what's the error message as it didn't work? Or just no data had been transfered?
I managed to export data from SQL2005 database to SQL2000 in this way:
1. Open Management Studio, explore 'Databases'->right click 'Mydb'
2. Choose 'Tasks'->'Export data', and follow the steps in 'Import and Export Wizard'.
