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,
asked Dec 14 '09 at 02:06 PM in Default
How about take a Full backup, restore to a new, temporary, database and then any exports you do from there will be from a consistent moment-in-time and won't interfere with their live database.
Assuming that they have enough disk space ...
... first job after Restoring might be to SHRINK the new temporary database, that would release any unused space.
... or you could just take the backup file off-site and restore on your SQL box and export etc. from there (assuming they are happy for the DB to go off-site - given that they are presumably happy for the XLS to go off site I reckon its as broad as it is long :) )
answered Dec 14 '09 at 02:13 PM