Le blog de Jean David TECHER, un Réunionnais à Saint-Priest/Lyon

Aller au contenu | Aller au menu | Aller à la recherche


samedi 12 septembre 2015

Lien pour MySQL

http://www.tux-planet.fr/activer-le-mode-read-only-sur-un-serveur-mysql/

lundi 13 janvier 2014

SQL Server 2000 (Enterprise Edition) on Linux 64

Wine 1.6.2 is used. Tools like 'Enterprise Manager', 'Query Analyzer', 'OSQL' are used. The Server 2000 is running on Linux

lundi 6 janvier 2014

SQL Server 2000 Standard Edition (+SP4) on Linux using Wine

For the moment I am able to get SQL Server 2000 Standard Edition + SP4 working on Linux using Wine 1.7.10. Two days were required to be able to set everything up! Only TCP/IP works but it is worth having that :).

1. Prerequistes

Wine 1.7.X must be installed -- where X=8,9,10 --. wine must be available /provided in your PATH. Your folder where wine is installed must be added in your environment variable. Since I am used to build wine from source I have to do
export PATH=/opt/wine/apps/SQL_Server_2000/bin/:PATH

2. Installation

In a nutshell you have to
  • make a fresh MSDE SP4 installation. This step is not very complicated.
    • Set up a new/fresh WINEPREFIX
      export WINEPREFIX=/where/you/want/your/SQL/Server/to/be/installed
    • Use winetricks
      winetricks vcrun2003
      This command above aims at copying expected DLL into your $WINEPREFIX
    • Set the DLL mscvp71.dll and msvcr71.dll as native through winecfg
    • Download SQL2000-KB884525-SP4-x86-ENU.EXE (google)
      wget ftp://ftp.akdeniz.edu.tr/Microsoft/SQL%20Server/SQL_Server_Service_Pack/Sql2000SP4/SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE
    • Run it. Command shown below will perform a silent installation using /S switch
      wine SQL2000-KB884525-SP4-x86-ENU.EXE /S
    • Go to the directory where the files have been extracted
      cd $WINEPREFIX/SQL2KSP4/MSDE
    • Generate a batch file
      echo 'setup.exe DISABLEROLLBACK=1 BLANKSAPWD=1 DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL TARGETDIR="C:\Program Files\Microsoft SQL Server\" DATADIR="C:\Program Files\Microsoft SQL Server\" /L*v C:\MSDE_Setup.log' > setup.bat
      Run it using wineconsole
      wineconsole setup.bat
    • The installer may crash and it can't end properly. However it didn't prevent your from going ahead.
    • You will have to copy a few DLLs...This step has to be completed!
  • Download the SQL 2000 Standard Edition (google)
  • Run the installer
    cd /path/where/your/CD/is/installed
    wine x86/setup/setupsql.exe
  • Choose the expected options to upgrade your current SQL Server installation based on MSDE.