Re: file conversion from SQL Server to Access

Tech-Archive recommends: Fix windows errors by optimizing your registry



You want to go the other way to most people
<grin>(http://support.microsoft.com/default.aspx?scid=kb;en-us;Q237980)

OK So there is no "Down sizing" tool i know.

How much of the SQL Server functionality do you want to take with you?

The two products are different animals and a one-one mapping of features is
not there.

DTS can be used to transfer the data and table structures ure but will no
move relationships, constraints, stored procs etc etc.



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"rseedle" <rseedle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:021088D1-058C-4CAA-B579-54BDC8C6F8BB@xxxxxxxxxxxxxxxx
> OK, how do I convert a SQL Server database file to an Access database file
> ?
>
> Randy


.



Relevant Pages

  • Re: SQL 2000 - Connection Error with DTS Packages
    ... After I changed all SQL Server 'Database Connection' steps in each of my DTS ... Package" option when you right click a DTS package name in ME. ...
    (microsoft.public.sqlserver.dts)
  • Re: vb.net dataTbl can DTS read?
    ... then using ADO to read/write the data to Sql Server. ... like what DTS does with Text Files, MS Access data, etc. ... Right now I am experimenting with writing the data from ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server DTS From Sybase
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > DataPump is used interchangeably with the transform Data Task ergo not the> ExecuteSQL task ... >>>> I want to import data from a Sybase database via a SQL Server DTS ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server DTS From Sybase
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > DataPump is used interchangeably with the transform Data Task ergo not the> ExecuteSQL task ... >>>> I want to import data from a Sybase database via a SQL Server DTS ...
    (microsoft.public.sqlserver)
  • Re: MS OLAP 3GB Limit
    ... platform is available for the 64-bit platform. ... Is it a requirement to run Data Transformation Services (DTS) on the ... DTS packages in a 64-bit SQL Server database. ... ODBC drivers where can we get this information is there ...
    (microsoft.public.sqlserver.olap)