View Single Post
  #1 (permalink)  
Old November 10th, 2003, 01:57 PM
Dmitriy Dmitriy is offline
Friend of Wrox
 
Join Date: Jul 2003
Location: , , .
Posts: 121
Thanks: 1
Thanked 0 Times in 0 Posts
Default 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
Reply With Quote