We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

SQL Upsize error in table

joop123456
joop123456 asked
on
Medium Priority
698 Views
Last Modified: 2008-02-01
Hi, these two tables are being skipped when upsizing to SQL Express, don't know how to solve it / where to look,...

---------------------------------------------------------------------------------------------------------------------------------
Table:      tblT1VerkoopContract
      Microsoft Access      SQL Server
      Table Name:      tblT1VerkoopContract
      Attached Table Name:
      Aliasing Query:
      Validation Rule:
      Skipping table 'tblT1VerkoopContract'...
      Server Error 102: Incorrect syntax near 's'.
      Server Error 105: Unclosed quotation mark after the character string ' ,
            OfferteID nvarchar (50)  ,
            Aanhef int  ,
            Afsluiting int  ,
            AanhefMEMO ntext  ,
            AfsluitingMEMO ntext  ,
            BevNieuw bit
          DEFAULT 1 ,
      )'.
      Table:      tblT2VerkoopContract
      Microsoft Access      SQL Server
      Table Name:      tblT2VerkoopContract
      Attached Table Name:
      Aliasing Query:
      Validation Rule:
      Skipping table 'tblT2VerkoopContract'...
      Server Error 102: Incorrect syntax near 's'.
      Server Error 105: Unclosed quotation mark after the character string ' ,
            ArrivalNoticeTEXT1 int
      ,
            AlleLoadordersVerstuurd datetime  ,
            Jaartal int
          DEFAULT 2006 ,
            HoofdItemID nvarchar (50)  ,
            HoofdItemrestrictieID int
      ,
            Herkomst nvarchar (50)  ,
            ContractBevestigd bit
          DEFAULT 0 ,
      )'.
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2006

Commented:
Taking a guess here - Do u have any quotes in your fieldnames?

what is the table definition in Access for

tblT1VerkoopContract

Author

Commented:
tblT1VerkoopContract:
---------------------------------------------------------------
VerkoopcontractAUTOID            AutoNumber
VerkoopcontractID            Text
Klant                        Text
KorteContractOmschrijving      Text
tblStatus                  Text
VerkoopBevestigingGestuurd      Yes/No
VerkoopbevID                  Text
VerkoopbevDatum                  Date/Time    With default value: Now()
VerkoopbevAanhefMEMO            Memo
VerkoopbevAfsluitingMEMO      Memo
OfferteID                  Text
Aanhef                        Number
Afsluiting                  Number
AanhefMEMO                  Memo
AfsluitingMEMO                  Memo
BevNieuw                  Yes/No

- No spaces, quotes, underscores etc.
- Removing all relationships does bot change anything when upsizing
- Removed all "Select distinct" etc. (just to try..)
Leigh PurvisDatabase Developer
CERTIFIED EXPERT

Commented:
Upsizing to SQL Express using what tool?

Author

Commented:
With the Access 2k3 upsize wizard..
Database Developer
CERTIFIED EXPERT
Commented:
I'm surprised it worked at all to be honest.
MS recommend using the utility found here
http://www.microsoft.com/sql/solutions/migration/access/default.mspx

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
MS recommend using.......

Why on earth does this "Access upsize utility" exists then,...?!?!?
Or let the user somehow know that something better is available,... from the same company.....
Incredible... I've spend a couple of da...  Nevermind.... :)

Allright, got zero errors but, but a big number of recommendations + info... Going to sort out that first..

Tnx for the help!
Leigh PurvisDatabase Developer
CERTIFIED EXPERT

Commented:
No, surely the point here is that you're using SQL 2005. (SQL Express)
It'd be somewhat unfair to judge MS too harshly on this point - as SQL Server 2005 is substantially newer than Access 2003.

The upsizing wizards work "OK" for earlier versions.  (But DTS was always better - but even DTS's replacement isn't present in 2005 Express)

I think it's actually cool that we have this tool to use with a high level of success in the mean time. :-)

Author

Commented:
Maybe a bit unfair, but on the other hand if there one softwarecompany who is good in 'your-version-aint-compatible today'-popups then we both know who that is. (But of course I know where on the end the software, read my database, more or less is coming from.)
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.