SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Downloading a changing SQL Server Database structure to Access


Downloading a changing SQL Server Database structure to Access

Author
Message
Peter Clements-368786
Peter Clements-368786
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search