Migration of an Access Database. How is the best way?

Hello there,

I am migrating an Access database to Sql Server. There are many many
problems with the access database (Schema and data) that need to be fixed in
the process.

What I was initially doing is writing a script which changes the schema and
data as I go. I then planned to run this script when we go live with the SQL
Server version. After working on this for a month or so I'm realising that
perhaps this isnt going to work. There are just too many changes and
scripting everything takes ages compared with just writing a new schema.

What I was thinking would be better would be to create a brand new schema
and just write a script to import the old data.

What do most people normally do?

Any advice would be very much appreciated
John Sheppard


.

Relevant Pages

  • Re: Bulkload - permissions
    ... What are the permissions of the process running the script? ... that the Sql Server account can see the schema. ...
    (microsoft.public.sqlserver.xml)
  • Re: automate tool to change column type?
    ... schema ahead of time. ... is the change such that you can do it with ALTER TABLE? ... but save and carefully review the script. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.tools)
  • Re: WSH in VS.NET 2003?
    ... or will wsh xml include a ... Get the "TechNet Script Center Sample Scripts" ... Other|Useful Scripting Technologies|Saving Data in XML Format ... There is no schema for getting MS. ...
    (microsoft.public.scripting.wsh)
  • Re: Synchronization Wizard weirdness
    ... Using the Oracle Enterprise Manager and Oracle Change Manager packages, ... :> I have a Test Schema in the same database as the Main schema and need to ... Wizard between the Main schema and Test schema -- obviously returned the full ... :> All seems to go well, until the script actually runs. ...
    (comp.databases.oracle.tools)
  • Re: Rebuilding the system schema
    ... a way to rebuild the system schema to get all of the objects back in? ... this a production database? ... This was the system user- logged in as system and ran a script that ... tablespace from your archived redo logs. ...
    (comp.databases.oracle.server)
Loading