Move my Access-Database to SQL-Server

[Guest]

Hi,

I want to move my Access-database to an SQL-Server and I want to create a
script to run in the SQL QueryAnayzer to build the new database, preserving
primary keys, indexes and constraints.
Or is there another way to do this?
I cant find a menu in Access that says "Generate SQL-script", like there are
in SQL-Server.

Moving the data is a smaller problem, I can always import it manually via
the Import wizard in SQL-Server.

 

[Guest]

Access has an upsizing wizard that can help move the tables and queries to
SQL. I
have never had great sucess with it, but it does most of the work.
Tools -> Database Utilities -> Upsizing Wizard

 

[Paul Ponzelli]

I've had very good experiences using the Upsizing Wizard to move my tables
to SQL Server. So if that's all you need to do, be sure to select the
option to only upsize the tables at the appropriate point in the Wizard.

Another tip would be to make sure all the tables to be moved have a primary
key.

hth

Paul

 

[John Vinson]

Another tip would be to make sure all the tables to be moved have a primary
key.

It's also a good idea to be sure that fieldnames and tablenames
contain NO blanks, and preferably only [A-Z][0-9] and _ and start with
a letter.

John W. Vinson[MVP]