Results 1 to 9 of 9
  1. #1
    Join Date
    Mar 2008
    Posts
    55

    Unanswered: Testing SQL Statements

    Im working with a SQL Server that i have limited access to. Is there a program (freeware preferred) that i can use to run my DDL against to verify it will process correctly when run on the SQL Server? Thanks.

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    Are you talking about something like this?
    http://www.microsoft.com/express/sql/default.aspx

  3. #3
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    click the blue check in Query Analyzer/New Query window.

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    That'll parse for syntax errors but won't handle name resolution.

    It sounds like you need a test environment - run your update scripts on test before deploying to prod.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    Why don't you install Developer Edition on your machine? Typical cost about $50.

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    SQL Server Express is free
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    But it misses plenty of stuff, including SQL Agent, and isn't much use if prod is Enterprise. 25 squids is a bargain.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  8. #8
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    There is no such thing as free software. Developer Edition is much better value than Express for development and testing purposes - unless you are testing for an Express deployment of course in which case you should use Express.

  9. #9
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Developer edition is that cheap?!
    Wow, I might have to upgrade from Express at home!
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •