Post reply

Upload Access DB Schema?

  • September 28, 2007 at 7:21 am

    #177631

    I need to create a couple of new databases on our Dev box and populate them with the schema-only components of a couple of Access Databases. I've looked in BIDS, but the only tools for copying over database objects appear to be for SQL Server DBs, not Access DBs.

    I don't want to upgrade the whole Access DB (data and all) because there's new development to be done to the schema. But I can't seem to find an easy way of getting the structure without literally (manually) typing the individual T-SQL statements to create all the tables.

    Any thoughts?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • September 28, 2007 at 7:32 am

    #737114

    Upgrade your access database - data and all. Then, use SSIS to copy your objects from SQL Server to SQL Server without the data.

  • September 28, 2007 at 7:33 am

    #737115

    Actually, I found an easier way. Apparently Access 2003 DOES allow upsizing the table structures only.

    Last time I upsized a DB, it was Access 97. Talk about behind the times! @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply