Switching from Pervasive to SQL

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: MDB (anonymous_at_discussions.microsoft.com)
Date: 09/04/04 

Date: Sat, 4 Sep 2004 09:25:50 -0700

Hello,
I recently built a VB6 application that interfaces to a
Pervasive accounting database. The customer will be
upgrading their database engine from Pervasive 2000i to
the latest version of MS SQL. I'm using a System DSN to
connect to the Pervasive database. Once we upgrade, I'm
assuming I can just create a different DSN that points to
the new SQL database. Is there anything in the SQL syntax
that will change once we upgrade? For example: I use a
simple query to grab all customers from the database like:
SQL = "SELECT * FROM ARCUS"

Once we move to SQL, will this statement change in anyway?
Someone told me that I may need to append the database
name but he was not sure. Something like:

SQL = "SELECT * FROM DBNAME.ARCUS"

Any information would be greatly appreciated. thanks

Relevant Pages

  • Re: Deploying new app. Upgrade theory
    ... After many posts before I started converting, I was going to go with A2000, ... customer, where if the customer does specify a customer ... to your invitation to do the upgrade for free. ... Upon launching the app, if I detect that the database is blank, ...
    (comp.databases.ms-access)
  • Re: Database owner after SQL 2005 upgrade
    ... I don't believe this is new behavior with SQL Server 2005. ... upgrade a SQL Server 7 database to SQL Server 2000, ... database in the compatibility mode that matches the product version it came ...
    (microsoft.public.sqlserver.setup)
  • Re: OOP - a question about database access
    ... >>and project so much better in SQL DBMSes than in ODBMSes, ... >>100x more bytes from the database, just because you want your objects to ... > a related invoice.. ... > assoication from the customer to the invoice collection and have done ...
    (comp.object)
  • Re: Desperate - WSS2.0 upgrade to WSS 3.0 trashed DB no either won
    ... You could install SQL 2005 Studio Management Express and attach the database from your SQL environment. ... to upgrade the database, but as I have stated earlier, I can't upgrade using ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... MSDE to store SharePoint uses the MSSQL$SharePoint database, ... SharePoint named instance to full SQL. ... You cannot upgrade the Monitoring instance to SQL ... What I see is the SQL server group and under ...
    (microsoft.public.windows.server.sbs)