Results 1 to 4 of 4

Thread: Convert SQL 2005 Express to SQL Compact 3.5

  1. Aug 24th, 2009, 12:10 PM #1
    ghall426
    ghall426 is offline

    Thread Starter
    Member
    Join Date
    Sep 2006
    Posts
    63

    Convert SQL 2005 Express to SQL Compact 3.5

    I have a VB program written with VB 2005 and using SQL express 2005. I just got a new computer and installed VB 2008. It seems the program converted correctly, but I am unable to connect to the database. I assume this is because I no longer have SQL express 2005 installed.

    Can I somehow convert the database to work with SQL Compact 3.5?

    Greg
    Reply With Quote Reply With Quote
  2. Aug 24th, 2009, 01:24 PM #2
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: Convert SQL 2005 Express to SQL Compact 3.5

    Why not just install SQL Express?

    In short, it's possible but it may take a little work. SQLCE is a subset of the full SQL, so somethings (like sprocs) are not supported. Also some datatypes may need to be changed.

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  3. Aug 25th, 2009, 02:24 AM #3
    ghall426
    ghall426 is offline

    Thread Starter
    Member
    Join Date
    Sep 2006
    Posts
    63

    Re: Convert SQL 2005 Express to SQL Compact 3.5

    So if I install SQL express 2008, is the 2005 database automatically compatible or will I need to convert it from 2005 to 2008? And if so, is this easily done?
    Reply With Quote Reply With Quote
  4. Aug 25th, 2009, 07:31 AM #4
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: Convert SQL 2005 Express to SQL Compact 3.5

    compatible - yes.
    Will you need to convert it - no. Unless you want to take advantage of additional 2008 features - but I think those are only in the full version of SQL
    easily done - yep. Just grab the MDB and LDF files... install 2008, then attach the files. Done.

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    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