August 31, 2009 at 3:26 am
I have to transfer all the db objects include tables,stored procedures, views , functions from SQL Server 2005 to MS Access DB. Now if it would be data transfer I could transfer the data by SSIS, But I have to move entire db objects.
Or, is there anyway ; where i can restore .bak backup to ms access db (.mdb)
Thanks & Regards
Vinod.km
August 31, 2009 at 12:13 pm
Basically it isn't going to be easily possible to do all of these. You can probably transfer the tables by using the External File Import function in Access. There is no direct equivalent of Stored Procedures in Access. If the Stored Procedure is a simple SELECT you might be able to do a query, otherwise it will take coding. Views can probably be converted to queries unless they have SQL Server unique things in them. Functions don't have an equivalent in Access, they will require coding.
The question is WHY do you want to try to do this. If the issue is cost, there are free versions of SQL Server that can be used.
If they want to do some Access reporting or forms using the data then use a Linked table to the SQL Server data.
IMHO, it isn't worth trying to do this. The norm is to do it the other way around and move data from Access to SQL Server.
August 31, 2009 at 1:32 pm
I agree with Royce's comments.
You haven't given us any idea on the number and size of the tables, nor how complex your sprocs and views are.
If it is a very "simple" SQL db then you may have a chance using Access ADP (Project).....but the question is really why do you want to do this?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 2, 2009 at 7:50 am
If you have the urge to migrate SQL Server objects to MS Access, the best thing to do is to lay down in a locked dark room until the urge passes.
If the urge does not pass, then take a hammer and hit yourself in the head. The feeling will be the same, but it will last much less and your chances of recovery will be better.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply