Friday, February 17, 2012

Export sql server express 2005 to 2000

Hi,

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'.

No comments:

Post a Comment