Using Upsizing Wizard to Migrate from Access 2003 to SQL Server 2000

[Deecrypt]

Hi all,
After reading a few posts in this group, I've come to the conclusion
that I should use the upsizing wizard to migrate my current Access
2003 database to SQL Server 2000 database. I am planning to get the
Mary Chipman book as it seems quite useful but had a few queries.

1) I will be migrating to an existing SQL 2000 database. I know thats
possible but can I expect any issues? Will I get any errors to tell
me of same named tables names in source and destination?

2) Do queries, macros and modules also get migrated? Are there any
exclusions?

Thank you kindly
Khurram

 

[Van T. Dinh]

See Tony Toews' article:

http://www.granite.ab.ca/access/sqlserverupsizing.htm

 

[aaron.kempf]

I would reccomend talking to SQL Server people instead of people that
are stuck in the 80s

anyone around here is too stupid to spell SQL

seriously.

spend some time with SQL; take a class; or get a book; and then post
questions to a sql newsgroup.
not an Access newsgroup.

anyone using MDB for anything in the year 2007 should be fired and
then spit upon

 

[aaron.kempf]

macros and modules are migrated.

some queries are migrated; but it's reccomended to do this:

a) loop through queries and get the SQL on the access side
b) store this sql in a table with 2 columns asql and tsql (Sql server)
c) when you find something that needs to be changed do it via a
replace
d) be careful; test lots
e) rinse and repeat

I can migrate a couple hundreds reports in a matter of a day or two.

I'm doing it for the gov't starting asap

 

[aaron.kempf]

sorry I forgot part

f) try to use the sql to create a view and then a sproc
- views are more like queries in MDB you can stack them on top of one
another
- sprocs are for action queries and for more complex queries; joins,
temp tables, parameters; etc

g) i store parameters in a table and use subqueries to get them back
out. it's a lot more rational than building a billion sprocs with a
billion parameters

 

[Deecrypt]

Thank you Dinh and Aaron. Hopefully this combined with the Chipman
book and Tony Towes articles will help me through this.

Cheers
Khurram