to create a table with a binary column with a default value

Posted on 2011-10-20
Last Modified: 2012-05-12
I have a sybase table that I am trying to port to sqlserver 2005

Sybase table has a table with binary(10) type column, with a default 'X0000000000'
when SSMA converts this, it complains about the default value
is there anything we can set up in SSMA for it to use this default to move it to sqlserver?  
Question by:nanjo85
    LVL 26

    Expert Comment

    you should do conversion..
    this link may help you
    LVL 75

    Accepted Solution

    You should be able to use 0x0000000000 (no quotes) or simply 0

    Author Closing Comment

    Excellent. one short sentence. Worked exactly as stated. thanks

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Suggested Solutions

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now