Export relations from SQL Server Database to MS Access

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Bose
    #1

    Export relations from SQL Server Database to MS Access

    Hi
    I have to make export of SQL Server Database to MS Access and I have
    done it with the tables but now I need to transfer(export ) the
    relations, keys and indexes. Can any1 tell me how to read relations,keys
    and indexes from SQL Server and convert them to MS Access.(it seams that
    for creation of indexes in MS Access ADOX is the only way but ADOX
    cannot read all information about keys,indexes from SQL Server.)
    All I can see is that I have to use SQLDMO to enumarate all
    realtion/keys/indexes from SQL Server database and use ADOX to create
    this relations/keys/indexes in MS Access database, but I don't know
    exact matching attributs of relations/keys/indexes from SQL to Access.

    Thanks

    Tags: None
    • John Bell
      #2
      Re: Export relations from SQL Server Database to MS Access

      Hi

      You posted the same question in microsoft.publi c.sqlserver.pro gramming. If
      you are not sure about the answers you were given then please do not cross
      post.

      John
      "Bose" <bosejob@sympat ico.ca> wrote in message
      news:ztBFc.9711 1$Ax1.1377116@n ews20.bellgloba l.com...[color=blue]
      > Hi
      > I have to make export of SQL Server Database to MS Access and I have
      > done it with the tables but now I need to transfer(export ) the
      > relations, keys and indexes. Can any1 tell me how to read relations,keys
      > and indexes from SQL Server and convert them to MS Access.(it seams that
      > for creation of indexes in MS Access ADOX is the only way but ADOX
      > cannot read all information about keys,indexes from SQL Server.)
      > All I can see is that I have to use SQLDMO to enumarate all
      > realtion/keys/indexes from SQL Server database and use ADOX to create
      > this relations/keys/indexes in MS Access database, but I don't know
      > exact matching attributs of relations/keys/indexes from SQL to Access.
      >
      > Thanks
      >[/color]


        Comment

        • Bose
          #3
          Re: Export relations from SQL Server Database to MS Access

          I do that becouse I didn't get the answer. I need some page where I can
          see Access contraparts of SQL Server keys/indexes.

          John Bell wrote:[color=blue]
          > Hi
          >
          > You posted the same question in microsoft.publi c.sqlserver.pro gramming. If
          > you are not sure about the answers you were given then please do not cross
          > post.
          >
          > John
          > "Bose" <bosejob@sympat ico.ca> wrote in message
          > news:ztBFc.9711 1$Ax1.1377116@n ews20.bellgloba l.com...
          >[color=green]
          >>Hi
          >> I have to make export of SQL Server Database to MS Access and I have
          >>done it with the tables but now I need to transfer(export ) the
          >>relations, keys and indexes. Can any1 tell me how to read relations,keys
          >>and indexes from SQL Server and convert them to MS Access.(it seams that
          >>for creation of indexes in MS Access ADOX is the only way but ADOX
          >>cannot read all information about keys,indexes from SQL Server.)
          >>All I can see is that I have to use SQLDMO to enumarate all
          >>realtion/keys/indexes from SQL Server database and use ADOX to create
          >>this relations/keys/indexes in MS Access database, but I don't know
          >>exact matching attributs of relations/keys/indexes from SQL to Access.
          >>
          >>Thanks
          >>[/color]
          >
          >
          >[/color]

            Comment

            • John Bell
              #4
              Re: Export relations from SQL Server Database to MS Access

              Hi

              I don't think you will get a more authorative answer than from Mary.

              Have you considered MSDE?

              John

              "Bose" <bosejob@sympat ico.ca> wrote in message
              news:bNKFc.1997 20$207.2407231@ news20.bellglob al.com...[color=blue]
              > I do that becouse I didn't get the answer. I need some page where I can
              > see Access contraparts of SQL Server keys/indexes.
              >
              > John Bell wrote:[color=green]
              > > Hi
              > >
              > > You posted the same question in microsoft.publi c.sqlserver.pro gramming.[/color][/color]
              If[color=blue][color=green]
              > > you are not sure about the answers you were given then please do not[/color][/color]
              cross[color=blue][color=green]
              > > post.
              > >
              > > John
              > > "Bose" <bosejob@sympat ico.ca> wrote in message
              > > news:ztBFc.9711 1$Ax1.1377116@n ews20.bellgloba l.com...
              > >[color=darkred]
              > >>Hi
              > >> I have to make export of SQL Server Database to MS Access and I have
              > >>done it with the tables but now I need to transfer(export ) the
              > >>relations, keys and indexes. Can any1 tell me how to read relations,keys
              > >>and indexes from SQL Server and convert them to MS Access.(it seams that
              > >>for creation of indexes in MS Access ADOX is the only way but ADOX
              > >>cannot read all information about keys,indexes from SQL Server.)
              > >>All I can see is that I have to use SQLDMO to enumarate all
              > >>realtion/keys/indexes from SQL Server database and use ADOX to create
              > >>this relations/keys/indexes in MS Access database, but I don't know
              > >>exact matching attributs of relations/keys/indexes from SQL to Access.
              > >>
              > >>Thanks
              > >>[/color]
              > >
              > >
              > >[/color]
              >[/color]


                Comment

                Previous template Next
                Working...