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