p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Pro VB 6 (http://p2p.wrox.com/forumdisplay.php?f=73)
-   -   Upsizing problem (http://p2p.wrox.com/showthread.php?t=5981)

Dmitriy November 10th, 2003 01:57 PM

Upsizing problem
 
I am having problems to upsize two Access 2000 databases to SQL Server 2000. For one database everything works OK except Access queries. The Upsizing Wizard does not convert an Access query to stored procedure (nor view or table). How to convert an Access query to SQL Server stored procedure? For the second database the Upsizing Wizard did not work at all. For each converted table the report shows up the reason: "table has been skipped". Without any explanation why?
I've tried to convert the Access database to SQL Server database using DTS. It works for importing all tables with the data but all relations and validation rules have been lost??? All Access queries have been converted to tables (not to views or stored procedures???).
Is there any smooth right way to upsize an Access database to SQL Server database?
     Thanks in advance
                       Dmitriy

sal November 11th, 2003 11:44 AM

The upsizing wizzard will not convert queries to SQL SErver. You must convert them manually. also make sure that after upsizing the data to SQL Server you check all of your data types on your table to ensure that the proper datatypes have been used. Access sucks at doing this.

Read books on line on how to create stored procedures. In the meantime, you can create views on SQL server and link them to Access and filter them the same way on your front end. This will help you get started without too much of a headache to you and your users.

DTS does not create relationships. It only transfers date. It also does not upgrade your queries to views and stored procedures.





Sal

Dmitriy November 12th, 2003 10:16 AM

Thanks Sal,
I've got it already from the sites:
http://builder.com.com/5100-6388-5059624.html and
http://support.microsoft.com/?kbid=295231
articles. Yes, Microsoft is not "perfect". What is interesting the Oracle utility "Oracle migration workbench" to migrate data, all relations and constrains from Access database to Oracle is much better and smarter.

Thanks again,
          Dmitriy


All times are GMT -4. The time now is 08:56 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.