[dba-SQLServer] importing Access data

if you are very strict about the naming convention of objects in your sql 
server db, i would suggest to look over the names of the objects after you 
have imported the structures from access to sql server (ie. script it out 
from EM) and make any corrections if necessary.  I purely use dts or sql to 
do the data import but to replicate the db structure in sql server, maybe 
upsizing wizard is best way to go?  I'd prefer dts any day over upsizing 
wizard for copy the structure (i'm talking just about the table structure, 
not data) but have not been able to figure out how to transfer the defaults 
in access into sql server; if anyone knows how, i'd be interested to know.

Billy

>From: "Susan Harkins" <ssharkins at bellsouth.net>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: "SQLList" <dba-SQLServer at databaseadvisors.com>
>Subject: [dba-SQLServer] importing Access data
>Date: Fri, 19 Aug 2005 12:23:28 -0400
>
>I've got an existing SQL Server database and an Access database. The client
>wants to dump the Access data into the SQL Sever database and dump the .mdb
>file completely. This is a one-time job.
>
>I figure I have two approaches:
>
>1. We can clear a block of time to manually import the Access data. I'd be
>working with a backup copy and they'd have to agree not to use the SQL
>Server database while I was importing --
>2. After reviewing the backup, I could write the necessary stored 
>procedures
>and let them run them to import the data themselves. That way, they 
>wouldn't
>have any downtime.
>
>Any comments? Any other suggestions? I don't have to convert anything other
>that Access datatypes that won't import as is -- any comments about that? I
>don't anticipate much trouble outside of maybe having to dump some dates,
>but I haven't reviewed the Access data yet, so that might not be necessary.
>
>Susan H.
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>