Announcement

Collapse
No announcement yet.

Importing Issues from MSSQL

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Importing Issues from MSSQL

    • Clean Import
    • YAF V 1.0.0
    • vB 3.6
    • Remove ImpEx once import is complete and final
      ImpEx build version : 1.78
      You do not have MSSQL support in this version/compile of php, the importer will not be able to connect to the source database.
      Read this : PHP MSSQL
    This is the source:

    <?php
    #################################################################### |;
    # vBulletin - Licence Number xxx
    # ---------------------------------------------------------------- # |;
    # Copyright ©2000–2007 Jelsoft Enterprises Ltd. All Rights Reserved. |;
    # This file may not be redistributed in whole or significant part. # |;
    # ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # |;
    # http://www.vbulletin.com | http://www.vbulletin.com/license.html # |;
    #################################################################### |;

    # The following settings allow ImpEx to connect to the vBulletin 3
    # database into which you will be importing data.

    # If impex is installed in vBulletin you can ignore the target details
    # as includes/config.php

    if (!defined('IDIR')) { die; }

    # For mysqli enter mysql
    $impexconfig['target']['databasetype'] = 'mysql';
    $impexconfig['target']['server'] = 'localhost';
    $impexconfig['target']['user'] = 'new db login';
    $impexconfig['target']['password'] = 'new db password';
    $impexconfig['target']['database'] = 'new database';
    $impexconfig['target']['tableprefix'] = '';
    $impexconfig['target']['charset'] = '';


    # If the system that is being imported from uses a database,
    # enter the details for it here and set 'sourceexists' to true.
    # If the source data is NOT stored in a database, set 'sourceexists' to false

    $impexconfig['sourceexists'] = true;

    # mysql / mssql
    $impexconfig['source']['databasetype'] = 'mssql';
    $impexconfig['source']['server'] = 'mssql08.1and1.com';
    $impexconfig['source']['user'] = 'MSSQL username';
    $impexconfig['source']['password'] = 'MSSQL Password';
    $impexconfig['source']['database'] = 'MSSQL Database';
    $impexconfig['source']['tableprefix'] = '';
    $impexconfig['target']['charset'] = '';


    # Error logging will log import errors to a database table impexerror
    # for use with support.
    # Language file is the file of phrases to be used, default is english.
    # pagespeed is the second(s) wait before the page refreshes.

    $impexconfig['system']['errorlogging'] = true;
    $impexconfig['system']['language'] = '/impex_language.php';
    $impexconfig['system']['pagespeed'] = 1;

    define('impexdebug', false);
    define('emailcasesensitive', false);
    define('forcesqlmode', false);
    define('skipparentids', false);
    define('shortoutput', false);
    define('do_mysql_fetch_assoc', false);
    define('step_through', false);
    define('lowercase_table_names', false);
    define('use_utf8_encode', true);

    ?>

    When I change from true to false I get the following message when trying to check and update the database:

    You have set sourceexists to FALSE in ImpExConfig.php, this means you do not want to import from a database system, this system is a source database system.

    Thanks for the help...

    J.T.
    Last edited by RedefiningFate; Tue 20 Feb '07, 5:33pm.

  • #2
    You will need to move the source database to the same server as vB.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      I guess I don't understand. Before we signed up for vB we had Jerry check to see if we could import our users and everything. He did so successfully onto a test vB system for us. All I remember giving him was a back-up file of our MSSQL database...how did he transfer our users over from that?

      Should I take the back-up file and move it to the server where my vB is hosted? But I don't understand if that is the case how ImpEx would import our users and everything...

      Thanks for your help and hopefully understanding my problem and questions...

      J.T.

      Comment


      • #4
        He installed the backup file to the server where his test vB was running. You will need to do the same because that server does not allow remote connections.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          Forgive my ignorance...this is all new to me...but I run an MySQL database on a linux server and don't have any place that I can install the MSSQL back-up file...as far as I know on my VPS...what would you suggest?

          Comment


          • #6
            You or your host will need to install MS SQL on your server and make sure that PHP is properly compiled with MS SQL support.

            The only other option is to install vB on the server with the MS SQL database, do the import there, then move the vB database to the new server.
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment


            • #7
              Ok...that gives me some options thanks a lot Steve...does vB run on MSSQL I thought it didn't...

              Comment


              • #8
                No, vB requires MySQl so that other server will need to have this installed.
                Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                Change CKEditor Colors to Match Style (for 4.1.4 and above)

                Steve Machol Photography


                Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                Comment


                • #9
                  Is there any other way that this can be done? I'm not able to install MSSQL on my VPS. Not able to remote into 1and1.com's database server address...I can create a back-up file of the MSSQL database but have no way to transform it into a MySQL database for vB...

                  Comment


                  • #10
                    Sorry but the only ways I know to do this are what I've already outlined.
                    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                    Change CKEditor Colors to Match Style (for 4.1.4 and above)

                    Steve Machol Photography


                    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                    Comment


                    • #11
                      Hey Steve what would you recommend for a host that has both MySQL and MSSQL installed?

                      Comment


                      • #12
                        I really don't know of any such hosts, but then again I don't keep track of MSSQL hosts. You can try asking in the vB Hosting Options forum.
                        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                        Change CKEditor Colors to Match Style (for 4.1.4 and above)

                        Steve Machol Photography


                        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                        Comment


                        • #13
                          Ok, I found a host that has both MSSQL and MySQL and allows me to remote connect to both. I finally get to the steps where I can run the modules and it says it takes some time to do each module...but when I go to users it shows no users other than the test users I created.

                          When I ask it to check and update database I get the follwing:

                          Altering tables

                          ImpEx will now Alter the tables in the vB database to include import id numbers.This is needed during the import process for maintaining refrences between the tables during an import.If you have large tables (i.e. lots of posts) this can take some time.They will also be left after the import if you need to link back to the origional vB userid.
                          moderator - importmoderatorid Completed
                          usergroup - importusergroupid Completed
                          ranks - importrankid Completed
                          poll - importpollid Completed
                          forum - importforumid Completed
                          forum - importcategoryid Completed
                          user - importuserid Completed
                          style - importstyleid Completed
                          thread - importthreadid Completed
                          post - importthreadid Completed
                          thread - importforumid Completed
                          smilie - importsmilieid Completed
                          pmtext - importpmid Completed
                          avatar - importavatarid Completed
                          customavatar - importcustomavatarid Completed
                          customprofilepic - importcustomprofilepicid Completed
                          post - importpostid Completed
                          attachment - importattachmentid Completed
                          pm - importpmid Completed
                          usernote - importusernoteid Completed
                          phrase - importphraseid Completed
                          subscription - importsubscriptionid Completed
                          subscriptionlog - importsubscriptionlogid Completed
                          AccessMask NOT found.
                          Active NOT found.
                          Attachment NOT found.
                          BannedIP NOT found.
                          Board NOT found.
                          Category NOT found.
                          CheckEmail NOT found.
                          Choice NOT found.
                          Forum NOT found.
                          ForumAccess NOT found.
                          Group NOT found.
                          Mail NOT found.
                          Message NOT found.
                          NntpForum NOT found.
                          NntpServer NOT found.
                          NntpTopic NOT found.
                          PMessage NOT found.
                          Poll NOT found.
                          Rank NOT found.
                          Registry NOT found.
                          Replace_Words NOT found.
                          Smiley NOT found.
                          Topic NOT found.
                          User NOT found.
                          UserForum NOT found.
                          UserGroup NOT found.
                          UserPMessage NOT found.
                          WatchForum NOT found.
                          WatchTopic NOT found.

                          But the other modules act as though they are working, but nothing ever comes of them.

                          What do you suggest?

                          Thanks...

                          Comment


                          • #14
                            Dumb question after re-reading the manual for the umteenth time...the source BB (in my case YAF) needs to be located on the same server as the new vB forum correct? Right now I have the MSSQL database installed on my host and connecting to it right now without having the actual board installed on my host...is that the problem I am experiencing...

                            Thanks

                            Comment


                            • #15
                              Yes, you need to have the source db on the same server as vB.
                              Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                              Change CKEditor Colors to Match Style (for 4.1.4 and above)

                              Steve Machol Photography


                              Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                              Comment

                              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                              Working...
                              X