Upsizing Wizard

Hot Topic

SQLExpress database file auto-creation error
What's the scope of the 'global Dts object' referenced from a Script Task?
Privileges for Deploying Reports
Current security context is not trusted
Error 1418, fails to connect mirror server
Using Forms Authentication in Reporting Services
error : 18452 in clustering; very urgent
What's the scope of the 'global Dts object' referenced from a Script Task?
Migrate SQL 2000 to New SQL 2005 Installation.
Executing .sql file using in .NET

SQL Server

Sql srv 2005 client components ?
Sizing Header Dynamically
Working around Temp tables in Reporting services.
declare programaticly a X number of variables
Retrieving a piece of datalogged equipment by most recent time
FTP Task will not execute when scheduled as a job
Connecting to SQL server 2005 express in LAN Using C# express
Watermark Generation is Invalid Error
SSAS 2005 on Windows XP?
Help: sort by total field

Upsizing Wizard

A few days ago I installed SQL Server 2005 Express edition and successfully used the upsizing wizard to convert a MS Access database to SQL Server database. Today I found I could get VB.Studio Express. The instructions said to delete SQL Server Express and .NET before installing VB Studio because it would re-install them both. I faithfully did that but since then I have been unable to get the upsizing wizard to work again. I have uninstalled SQL Server and re-installed it but still cant get it working. From SQL Server Configuration manager I can confirm that Shared Memory and TCP/IP protocol are both enabled for both protocols for clent and protocols for SQLEXPRESS Both the SQL Server and the SQL Browser are running. And from SQL Server Surface Configuration I can confirm that OPENROWSET AND OPENDATASOURCE SUPPORT is disabled; CLR Registration is disabled; OLE AUTOMATION is enabled; and xpCommandshell is disabled.

When I run the upsizing module it goes through the motions but the report at the end says "table was skipped or export failed" for each of the tables in the database.

I have looked everywhere I can think of to try to find a solution but no one so far has been able to help.



Answer this question

Upsizing Wizard

  • Bevin R Brett

    I have the same problem. I have been using the Upsizing Wizard for a few weeks now and it works fine. Now I have come across a database which has upsized OK before but now one of its tables will not convert ... it just says Table was skipped or export failed. I am using SQL Server 2000

    Help!



  • Mark Staples

    I have been having the same problem, when I upsize my database I recieve the same messages: Table was skipped or export failed, Can anyone hep

    I am trying to find the problem, don't know what else to do....



  • Sheng Jiang

    I don't know what will work for you, but only what worked for me. I also don't know which of the following steps are crucial. I reinstalled MSDE (I'm running this standalone), accepting all the defaults. In the setup line I included securitymode=sql. When it WASN'T working, in Access when the wizard asks for a password, previously I had not given one, then when the error message let me accept 'use trusted connection' I had. Instead in the iteration that DID work I used my 'sa' account name and the system administrator password I'd created in the process of installing MSDE. I sure hope this works for you. I can relate to the hours of frustrating lack of headway!

  • Rudolf Dvoracek

    Same problem but many times there are no errors, but I do NOT get all of the data transferred Suggestions

  • davidwdf

    Even I am getting the same error but I dont know the solution. Please if anybody konws it, can share the details.

  • Chris_1246

    I'm having a problem with upsizing too. I get the error "table was skipped or export failed" no matter what .mdb file I try to upsize. I've spent two days trying to figure out why this is.
  • Upsizing Wizard
Answer this question