Migration from MS Access 7.0 to MS SQL Server 6.5 - NEED HELP 
Author Message
 Migration from MS Access 7.0 to MS SQL Server 6.5 - NEED HELP

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



Thu, 12 Aug 1999 03:00:00 GMT
 Migration from MS Access 7.0 to MS SQL Server 6.5 - NEED HELP

Hi

 There is an Access 7.0 to SQL Server 6.x  upsizer available free from the
MS web site. Just go to their site and do a search.
--
Regards
Bharat Ahluwalia
Aditi
Access 2.0 to SQL Server 6.x upsizer at http://www.aditi.com/updown
http://www.aditi.com/qcon



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



Thu, 12 Aug 1999 03:00:00 GMT
 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




Fri, 13 Aug 1999 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. How to migrate from MS-ACCESS to MS-SQL server 6.5/7.0

2. Help needed on migration from SqlAnywhere to MS Sql Server 6.5

3. Help Convert MS Access SQL to MS SQL Server 6.5

4. MS Access - SQL Server 6.5 Help needed!

5. MS Access - migration to - MS SQL Server

6. How to migrate from MS Access 97 to MS SQL server 6.5

7. How to Link MS Sql 6.5 to MS Sql 7.0

8. Making a MS-SQL 6.5 compatible database with MS-SQL 7.0

9. ms sql 6.5 vs ms sql 7.0

10. Connecting to MS SQL Server 6.5 via MS Access 97 and ODBC

11. Migration from MS Access 97 to SQL Server 7.0


 
Powered by phpBB® Forum Software