SQL Trial Version


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: SQL Trial Version

  1. #1
    PuffMan Guest

    SQL Trial Version


    I was wondering if anyone had to upgrade a trial version of sql with the real
    sql 7.0? Does the upgrade keep data in the tables intact?

    Thanks,

    Puffman

  2. #2
    Neil Pike Guest

    Re: SQL Trial Version

    > I was wondering if anyone had to upgrade a trial version of sql with the real
    > sql 7.0? Does the upgrade keep data in the tables intact?


    Q. How can I upgrade the 120-day evaluation version to the full SQL
    version?

    A. For SQL 6.5 :-

    1. One method would be to backup the databases, un-install SQL, re-install SQL
    and then load the databases again.

    2. A faster method is :-

    (a) Backup your databases first (just in case)

    (b) Copy over all the .dll's and .exe's from the full version, over the top
    of the evaluation version.

    (c) Then from the <sql>\binn directory run the following, making sure the
    case is correct

    setup /t RegistryRebuild = On

    (d) The setup routine will now run and ask you all the normal questions.
    Answer these as you did for the 120-day eval version (putting in the same paths
    etc.) and it will just update all the registry entries/icons etc. It will
    leave the databases alone.

    For SQL 7.0 :-

    (If you can connect to SQL then you can do the first 2, otherwise it doesn't
    matter, but you'll have to create the logins again manually)

    (a) Detach your user databases (sp_detach_db)
    (b) Create a script file for all logins (or BCP out sysxlogins)
    (c) Stop SQL Server
    (d) Backup all user database files - *.mdf/*.ndf/*.ldf
    (e) Un-install SQL Server eval
    (f) Install retail copy of SQL Server
    (g) Run script to create logins (or BCP in sysxlogins)
    (h) If user databases were deleted by un-install (they shouldn't be) then
    restore from backup
    (i) Attach user databases (sp_attach_db)

    ===

    v1.05 2000.01.28
    Applies to SQL Server versions : All
    FAQ Categories : Installation and Upgrades
    Related FAQ articles : n/a
    Related Microsoft Kb articles : n/a
    Other related information : n/a
    Authors : Neil Pike

    Neil Pike MVP/MCSE. Protech Computing Ltd
    (Please reply only to newsgroups)
    SQL FAQ (420 entries) see
    forumsb.compuserve.com/vlforums/UK/default.asp?SRV=MSDevApps (sqlfaq.zip - L7
    - SQL Public)
    or www.ntfaq.com/sql.html
    or www.sql-server.co.uk
    or www.mssqlserver.com/faq



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center