MS Access - SQL Server 6.5 Help needed!

MS Access - SQL Server 6.5 Help needed!

Post by Valery D Borisiu » Fri, 02 Oct 1998 04:00:00



Advice, pls better than Delphi's Data Pump instrument to transfer data with

all DRI correctly from Access to SQL Server.

I use Delphi's Data Pump to transfer tables,but all dependences transferres
not
correctly. To fix it I use ERWIN - but it's very complexive.

Sincerelly yours

 
 
 

1. 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

2. 16 bit ODBC, Netware, SQLServer 2000

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

4. Oracle/SQL Question

5. Need Help with ODBC/MS SQL Server 6.5/Peer Web Server 3.0/Frontpage Problem

6. Slow query to remote MSDE (SQL server)

7. Need help converting MS ACCESS query to SQL 6.5

8. VB3, Access, Required fields

9. MS ACCESS 97/SQL server 6.5: deadlock problems when accessing server tables

10. Need help to install and setup MS SQL Server 6.5

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

12. HELP: Exporting table from MS-ACCESS to SQL Server 6.5

13. MS SQL Server 6.5 / Access mdb Integration help