Migrate Access database into sql server and update automatically

Question

A system using  Microsoft office access as its back end database. now i need to migrate those data into microsoft SQL server, and every day update need from access into sql server . I migrate and export those data but next time could not update in sql server. But those are in access database only. How to keep those database in link?

Answer 1

These articles may help.

http://msdn.microsoft.com/en-us/library/bb188204(SQL.90).aspx

 http://www.microsoft.com/sqlserver/2005/en/us/migration-access.aspx

 

 

 

---

Regards, Dave Patrick .... Microsoft Certified Professional -Microsoft MVP [Windows]

Answer 2

Hi Sameel,

Hi agree Dave's links are good for general MS Access to SQL migration guidance. I recommend SSIS for the daily update from MS Access to SQL Server, please find the following link; - http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/ea3843d3-dcb2-4ce4-8346-f6e8148be4f0

I hope this helps.

Kind Regards,

Kieran.

---

If you have found any of my posts helpful then please vote them as helpful. Kieran Wood PGD SoftDev (Open), MBCS http://uk.linkedin.com/in/bileeds

Answer 3

It can migrate but the updates r not automatically add with sql database from access DB. how can?

Answer 4

Below link not longer available

http://msdn.microsoft.com/en-us/library/bb188204(SQL.90).aspx

---

Chirag Patel

Answer 5

Hi Chirag,

The following links are valid in relation to the original question; -

http://blogs.msdn.com/b/ssma/archive/2011/01/28/access-to-sql-server-migration-how-to-use-ssma.aspx

http://support.microsoft.com/kb/237980

http://msdn.microsoft.com/en-us/library/hh313084.aspx

I hope this helps.

Kind Regards,

Kieran.

---

If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI,MCC, PGD SoftDev (Open), MBCS http://www.innovativebusinessintelligence.com/ http://uk.linkedin.com/in/kieranpatrickwood