Re: Convert an Access database to SQL

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 05/12/04


Date: Tue, 11 May 2004 20:02:19 -0600

Access has an Upsizing Wizard to migrate an Access database
to SQL Server - you can find information on this in the
Access help files. You can also use DTS (Data Transformation
Services) in SQL Server to migrate your Access data to SQL
Server.
For the situation you describe and just using SQL Server for
development, the developers edition would be fine.

-Sue

On Tue, 11 May 2004 18:51:02 -0700, jje
<jevans1@verizon.net> wrote:

>I've seen software that claims it can convert an Access database into SQL one. Does anyone know how this works? Does Microsoft have a solution for this?
>
>I've only used Access databases and need to develop one with more power. For developing all I need is the developers edition right? My hosting server does have SQL.
>
>Thanks for helping a SQL newbie
>
>Joyce



Relevant Pages

  • working on sql server
    ... use Sql server for creating my database.My query is does ... SQL server developers edition is sufficient for creating ... price details of the developers edition and the licennce ...
    (microsoft.public.sqlserver.mseq)
  • MSDE2000 & SQL 7 ?
    ... I'm currently running SQL Server 7, Developers Edition, but would like ... to be able to Install MSDE 2000, so that I can learn/work with/use the ...
    (microsoft.public.sqlserver.msde)
  • scripting objects in sql server 2005
    ... ok...this sql server user has a seemingly ... very simple problem with his new developers edition of sql server 2005. ... I'm trying to script multiple tables and indexes in the mmc...and using ...
    (comp.databases.ms-sqlserver)
  • Re: Rename Local Server
    ... > I have installed the developers edition of the SQL Server onto my computer. ... specified during install. ... Aaron Weiker ...
    (microsoft.public.sqlserver.setup)
  • Re: tool to re-reference forms after usizing?
    ... Speed Ferret (which I hate to admit that I've never been able to get to ... tblCustomerAddress, remember that changing tblCustomer to something else ... >>> I am in the process of upsizing an access database to sql server. ...
    (microsoft.public.access.conversion)