CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. December 13th, 2011, 07:17 AM #1
    viperbyte's Avatar
    viperbyte
    viperbyte is offline Member +
    Join Date
    Dec 2009
    Posts
    596

    Query Converter Exist?

    Good morning all. I'm upsizing an Access database with a mess of complicated queries to MSSQL 2008. Is there any software that will convert these queries to MSSQL queries? I'm doing it by hand and it's so painful so I wondered if I was not enjoying the benifits of a wizard or something that existed to make my life easier. Does such an animal exist???
    Reply With Quote Reply With Quote
  2. December 14th, 2011, 08:17 AM #2
    HanneSThEGreaT's Avatar
    HanneSThEGreaT
    HanneSThEGreaT is offline Elite Member Power Poster
    Join Date
    Jul 2001
    Location
    Sunny South Africa
    Posts
    11,283

    Re: Query Converter Exist?

    I knowthere are a lot of applications out the re that can convert your Access database to an SQL Database. There is even an option in Access too. The problem is, that it will convert and create it as is. I will tell you the same as I tell everyone who wants to upgrade / convert their VB 6 projects into VB.NET, and that is, do it by hand. I know it will be painful and will most probably take up a lot of your time, but when it is done, it is done.

    I hope my post was helpful
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules




Click Here to Expand Forum to Full Width

Featured