Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
taunt
Posting Yak Master
128 Posts |
 Posted - 2013-06-06 : 12:16:03
|
| Hello I use to be on sql server 2005 (native client 9), now I'm using sql server 2008 (native client 10). The exporting a table to Access now takes 5 times as long to export. I can use sql manager 2005 to export the table, but that's a pain. Is there a way I can update the table to be more friendly exporting in sql 2008? What is the issue that might be causing this?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-07 : 01:58:36
|
| whats the size of the table? are you using export import wizard?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
taunt
Posting Yak Master
128 Posts |
Posted - 2013-06-07 : 11:39:59
|
| Sorry I don't know how to get the size in gigs out the table, but it's 878388 rows and about 20 colums. The export is usually arounf 2 gigs. I'm using the wizard at the moment. Later I plan on making a ssis package. |
|
|
|
taunt
Posting Yak Master
128 Posts |
Posted - 2013-06-07 : 18:25:00
|
| I think it's a 32 bit vs 64 bit thing. I'm exporting to a 32 bit Access file from a 64 bit SQL Server. Would that be the speed issue? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-08 : 03:21:25
|
| not any direct influence i would say. check if you've a better provider to connect to access------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Export to Access is real slow