Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Downloading a changing SQL Server Database structure to Access Expand / Collapse
Author
Message
Posted Friday, August 07, 2009 1:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 05, 2013 2:24 AM
Points: 7, Visits: 135
Hi,

I am working on a project that requires export of a sql server 2008 database to access mdb. The difficulties lie in that the sql server database structure may be modified from time to time, but the requirement is to be able to generate the new format sql server db without software change.

I believe this precludes use of standard ssis, that would require the table bindingsto be done up front.

I have a few ideas on how parts of the problem could be done, but gaps in providing the complete solution.

1. I could use SMO to script the sql database structure, then I need somehow to turn the sql server script into a script to create the access db

2. I could try to programatically use SSIS to 'discover' the sql database structure.

Any pointers as to the best way to proceed gratefully received; it seems 99.99% of the documents online describe access -> sql server upsizing, and not flows in the opposite direction.

Many Thanks

Peter
Post #766726
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse