Access to SQL Server

[MikeR]

I'm playing with SQL Server Express, and would like to convert an Access 2000 .mdb to
it. I'm using the Upsize wizard, and taking all the defaults to create a new
database. The fails with "Table was skipped, or export failed." for 4 of the 9 tables
in the Access db. AFAICT, the SQL Server db is not generated.
Is SQL Server Express suitable to replace Access in a desktop app (Not an Access app)?
Thanks,
Mike

 

[Peter Doering]

I'm playing with SQL Server Express, and would like to convert an Access
2000 .mdb to it. I'm using the Upsize wizard, and taking all the
defaults to create a new database.

The better tool is this one:
http://www.microsoft.com/sql/solutions/migration/access/default.mspx

The fails with "Table was skipped, or
export failed." for 4 of the 9 tables in the Access db. AFAICT, the SQL
Server db is not generated.

Try again with SSMA, you may get better/other messages.

Is SQL Server Express suitable to replace Access in a desktop app (Not an
Access app)?

SQL Server (Express) can host your tables, views, stored procedures etc.,
it won't replace forms/reports. If you want to replace Access as front end
you have to use something like ASP(.net) or VB(classic/.net) or ...

 

[MikeR]

The better tool is this one:
http://www.microsoft.com/sql/solutions/migration/access/default.mspx


Try again with SSMA, you may get better/other messages.


SQL Server (Express) can host your tables, views, stored procedures etc.,
it won't replace forms/reports. If you want to replace Access as front end
you have to use something like ASP(.net) or VB(classic/.net) or ...

Thanks Peter -
Worked great, nice tool. I'm amazed that MS left this feature out of SQL Server
xpress, and that the wizard in Access doesn't work.
Mike

 

[zhaoweisport]

Thanks Peter -
Worked great, nice tool. I'm amazed that MS left this feature out of SQL Server
xpress, and that the wizard in Access doesn't work.
Mike