I need to analysis a customer's sql server database, I don't have sql server myself. It's v8, pre SSIS, so I an looking at a dts export to excel, straight forward using the wizard.
The have a lot of tables so I am hoping to export them all as one excel file. The database shows in enterprise manager as 366mb. They access their database 24 7 so I am wary about locking/crashing it and don't know if that would be an issue.
Does anyone have an idea how long the export might take to run or any other observation/recommendations.
Thanks in advance,