upsizing advice MDB -> SQL

[snooper]

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!

 

[Stephen]

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.

 

[snooper]

mmm... interesting.
thanks!