Migration from MS Access 7.0 to MS SQL Server 6.5 - NEED HELP
Quote:
> There is 10MB Access database (about 40 tables, 50 queries, 50 procedures)
> that is accessed by 10 Access clients.
> Since this base will be considerably enlarged soon, i have decided
> transfere it to SQL server to avoid this problem in future.
> Of course, all the relationships inside must be saved and client parts must
> be able work with new base.
> Is there any way to do this automatically, or i must write code to export
> each table, restore all relationships and then link these table back to
> client base?
> Thanks
> --
> Kirill V. Florensky
I'm also working on a project to transfer a MsAccess 7.0 database to
SQL-server. I have used the upsize-tool from microsoft. It works but
the validation rules is a problem. The SQL-server doesn't have the
facility of field-validation like MsAccess and the upsize tool will
convert the field validations to a insert- and update-trigger. This is a
disadventage because now the validaton of the fields will be done on the
moment of saving, instate of the moment of leaving the field on the
form. Another point is that the creating of a trigger has some kind of
limit. I have to upsize a table with 90 attributes all with validations.
The triggers which were generate by the upsize tool, were to large.
I think there has to be another solution, but for now I haven't found
one.
I hope this give you some information about the use of the upsize tool.
Eric
