DDL / Schema extraction

Ask a Question related to ASP Database, Design and Development.

  1. #1

    Default DDL / Schema extraction

    Hi Guys

    If poss, could you please answer the following queries:

    1) Is there any way in Access 2000 that I can get the DB schema out?
    Ideally its for point 2 below, but just so that I can print it out to see
    what I've created/structured would be nice.

    2) I've been doing my new site with an Access DB, with the idea of using a
    MySQL equivalent for when it goes live.

    All my queries are in my include files and are not stored queries so there
    is only the table structures that I use in Access.

    Is there any way that I can export the DDL (I think this is the thing that
    you guys always like) from Access DB so that I only have to tweak certain
    areas to have myself a MySQL DB structure script?

    Rgds

    Laphan


    Laphan Guest

  2. Similar Questions and Discussions

    1. Text extraction
      Hi all How can I extract all the text from a 'real text' pdf, with two columns and not security, mantaining reading order. I´m using jsObject...
    2. PDF content extraction
      I've browsed CPAN. I've Googled. I'm stumped. I've successfully used PDF::Parse to get at PDF metadata. But I can't get at the content. Is there...
    3. DVD audio extraction
      I can get audio extracted from vob files with mplayer, but I was wondering if there were any tools to make it a bit easier. For example, I might...
    4. MySQL datetime extraction
      Given a date in MySQL datetime format, how do I extract the elements? That is get the month, day, year, hour, ... Thanks, Yasir
    5. Crisper extraction
      Alternatively, make a layer mask from the selection and blur that. Same effect as Tony's really.
  3. #2

    Default Re: DDL / Schema extraction

    Laphan wrote:
    > Hi Guys
    >
    > If poss, could you please answer the following queries:
    >
    > 1) Is there any way in Access 2000 that I can get the DB schema out?
    > Ideally its for point 2 below, but just so that I can print it out to
    > see what I've created/structured would be nice.
    >

    [url]http://www.aspfaq.com/show.asp?id=2178[/url]
    [url]http://www.aspfaq.com/show.asp?id=2177[/url]

    --
    Microsoft MVP -- ASP/ASP.NET
    Please reply to the newsgroup. The email account listed in my From
    header is my spam trap, so I don't check it very often. You will get a
    quicker response by posting to the newsgroup.


    Bob Barrows [MVP] Guest

  4. #3

    Default Re: DDL / Schema extraction

    Thanks Bob


    Bob Barrows [MVP] <reb01501@NOyahoo.SPAMcom> wrote in message
    news:eKW4E68KEHA.2236@TK2MSFTNGP09.phx.gbl...
    Laphan wrote:
    > Hi Guys
    >
    > If poss, could you please answer the following queries:
    >
    > 1) Is there any way in Access 2000 that I can get the DB schema out?
    > Ideally its for point 2 below, but just so that I can print it out to
    > see what I've created/structured would be nice.
    >

    [url]http://www.aspfaq.com/show.asp?id=2178[/url]
    [url]http://www.aspfaq.com/show.asp?id=2177[/url]

    --
    Microsoft MVP -- ASP/ASP.NET
    Please reply to the newsgroup. The email account listed in my From
    header is my spam trap, so I don't check it very often. You will get a
    quicker response by posting to the newsgroup.




    Laphan Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139