Import Export in SQL 2008 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Import Export in SQL 2008

Hi,
I have recently upgraded from SQL 2005 to SQL 2008.
To support legacy applications, I need to export data to MS Access.
The table export is taking several hours now, whereas it used to get completed within Minutes in SQL 2005.
Can you suggest a solution.

Welcome to the forum….
Did you update the stats after upgrade? if not update it…
Try running the query in Query window and see how much time it is taking?
If you have upgraded to different server then check if you have any network issues…

Hi,
Thanks for your advice. It seems to have worked.
I shrank the Log File after restroing the .bak file and then updated the statistics.

Hi,
I have another problem now, I get the following error messages when I Import a table to Access from SQL 2008.
Executing (Warning)Messages Warning: Preparation SQL Task 1: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (SQL Server Import and Export Wizard) Warning: Preparation SQL Task 1: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (SQL Server Import and Export Wizard) Could you please be kind to explain me the problem.

Welcome to the forums.
Have you upgraded same SQL Instance or is it a different instance?
If it is a different instance than the 2005 source then then check network connectivity between 2008 & MS Access machine has no issues.
Also what is the service pack level on SQL Serve after the upgrade?

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |