Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sundaram123
Starting Member
15 Posts |
 Posted - 2004-07-18 : 20:01:16
|
| I am converting MS-Access database into MSSQL Server database using upsizing tool. For some reason it’s skipping the tables. This MS-Access has only two tables with few records.I used dtswiz tools to upgrade the database its not upgrading filed properties (like auto number filed).I liked upsizing method, any tips to debug this problem.you can download database from this link its 22KB size.http://sfg.homeunix.com/io.zipThanksSRError Reports=============Upsizing Wizard Report 1Database Microsoft Access Database: C:\work\io.mdb SQL Server Database: ioSQL12Errors Table: LEO_Function Table was skipped, or export Table: Leo_FunctionAcct Table was skipped, or export Upsizing Parameters Table Attributes to Export Indexes Table relationships: Validation rules Not upsized Defaults Timestamp fields added: Structure only, no data Some tables Modifications to Existing Database Attach newly created Save password and SQL Server tables user ID with Tables Table: LEO_Function Microsoft Access SQL Server Table Name: LEO_Function Attached Table Name: Aliasing Query: Validation Rule: Skipping table 'LEO_Function'... Table: Leo_FunctionAcct Microsoft Access SQL Server Table Name: Leo_FunctionAcct Attached Table Name: Aliasing Query: Validation Rule:Skipping table 'Leo_FunctionAcct'... |
|
|
|
|
|
MS-Access to MSSSQL Server upgrade problem.