upsizing advice MDB -> SQL

General Web Coding Microsoft Development
1

hi all.

when i develop an app which will use an SQL db - i usually
do the following:

  1. design the tables/fields in Access
  2. run the EM Import/export Wizard to upsize the strcuture and existing data
  3. login thru the ASP.NET MSSQL Manager and fix all the Identity/Seed/Increment fields which dont seem to upsize properly from Access.

Is there an easier way to do this?

Thanks!

2

There is a free for personal use application called Aqua Data Studio that I recnetly learned about(here), it is really great.

Then there is SQL Server Management Studio 2005 Express Edition which MS has available free for download.

3

mmm… interesting.
thanks!