How to move tables from Access to SQL?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have some truly huge tables in an Access2002 database. I need to move these
tables to SQL on another server. The SQL space has been reserved for me.
Okay, what steps do I need to take to export the tables to the SQL server?

Thanks!
 
Make sure that all column and table names conform to SQL server standards.
Make sure that all tables have primary keys defined.
Remove any extraneous indexes.
Make sure that all relationships are correctly defined.
Once the tables are "perfect", just use the upsizing wizard and follow the
directions. Chose the option to link the tables to the existing db.
 
Back
Top