import database from MSAccess to SqlSERVER 2008.
Hi Friends I need to copy whole database from MSAccess to SqlSERVER 2008. then in next step how can done this in incremental way. i.e; I have an access database i want to import that in Sqlserver2008 next time when i execute this it will use max date for import. Kindly help Friends
October 11th, 2012 6:10am

Check this and this video on how to import data from MS Access to SQL. For incremental loads you would have to write a query in the OLE DB source filtering out records not matching the max date. Check this on how to write dynamic queries.http://btsbee.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
October 11th, 2012 6:50am

Hi btsbee First of all thanx for reply. may b i didn't write my issue clearly sorry for that. btsbee actually i need to copy database not table. so i want to know which task copy the database.? second if i tried to view video it is paid version..
October 12th, 2012 4:28am

I would use the Import&Export wizard to do the initial loading of the Access database. Save the package and modify it to do incremental loads.MCTS, MCITP - Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
October 12th, 2012 4:51am

I would use the Import&Export wizard to do the initial loading of the Access database. Save the package and modify it to do incremental loads.MCTS, MCITP - Please mark posts as answered where appropriate.
October 12th, 2012 4:51am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics