Requirement:

沂水網站制作公司哪家好，找創新互聯！從網頁設計、網站建設、微信開發、APP開發、響應式網站設計等網站項目制作，到程序開發，運營維護。創新互聯2013年開創至今到現在10年的時間，我們擁有了豐富的建站經驗和運維經驗，來保證我們的工作的順利進行。專注于網站建設就選創新互聯。

- sql server management studio

- mdb viewer plus / MS access

- mdb2sqlite

- java opensdk-jdk

1. download mdb viewer plus

open mdb view plus , create a blank mdb file (test.mdb) without password.

2. open sql server management, cmd > ssms.exe    

3. right click on database you want to export > tasks > export data .

4. select data source > sql server native client 11.0 > fill in auth information and make sure connection is working.

5. click next > select destination > Microsoft access (microsoft jet database engine) > select test.mdb

6. select all tables and all data will be exported to test.mdb.

7. download https://code.google.com/p/mdb-sqlite/  >

wget https://mdb-sqlite.googlecode.com/files/mdb-sqlite-1.0.2.tar.bz2

tar -zxvf mdb-sqlite-1.0.2.tar.bz2

cd mdb-sqlite-1.0.2/

8. install opensdk > apt-get install openjdk-6-jdk

9.  upload your test.mdb to mdb-sqlite-1.0.2 directory.

10.  java -jar dist/mdb-sqlite.jar test.mdb test.sqlite

umbraco database structure

Example :  article content type migration:

<?
/**
 * @file
 * test_migrate.module
 */
/**
 * Sqlite db connection helper.
 */
function _test_migrate_sqlite_connect() {
  $other_database = array(
    'database' => '/home/test/test.sqlite',
    'host' => 'localhost',
    'driver' => 'sqlite',
  );
  $key = md5('testmigrate');
  Database::addConnectionInfo($key, 'default', $other_database);
  return $key;
}
/**
 * Implements hook_menu().
 */
function test_migrate_menu() {
  $items = array();
  $items['admin/test_migrate'] = array(
    'title' => 'test data migration',
    'page callback' => 'test_migrate_page_test',
    'access arguments' => array('administer site configuration'),
    'type' => MENU_NORMAL_ITEM,
  );
/**
 * Migrate entry.
 * Get all node data from umbraco
 */
function test_migrate_page_test() {
  $key = _test_migrate_sqlite_connect();
  db_set_active();
  db_set_active($key);
  // Dsm all data.
   $sql = db_query('
select * from cmsPropertyData as cpd
inner join (select * from cmsDataType as dt left join cmsPropertyType as cpt on cpt.dataTypeId = dt.nodeId) as data on data.id = cpd.propertytypeid left join
cmsDocument as cd on cd.versionId = cpd.versionId left join
cmsContentVersion as ccv on ccv.versionId = cd.versionId left join
umbracoNode as ubn on ubn.id = ccv.ContentId inner join
cmsContentXml as ccx on ccx.nodeId = ubn.id left join
cmsContent as cc on cc.nodeId = ubn.id left join
cmsContentType as cct on cct.nodeId = cc.contentType left join
cmsDocumentType as cdt on cdt.contentTypeNodeId = cct.nodeId left join
cmsTemplate as ct on ct.nodeId = cdt.templateNodeId
where
cd.newest = -1 and
order by cpd.contentNodeId asc
limit 0, 4000');
  db_set_active();
  foreach ($sql as $k => $v) {
    dsm($v); // dsm all whole record.
    $nids[$sql_v->nid]['xml'] = $sql_v->xml; // XML node from umbraco.
  }
  foreach($nids as $nid_k => $nid_v) {
    debug = 1; // Debug mode.
    // Actually we can grab all node data from xml
    $doc = new DOMDocument();
    $doc->recover = TRUE;
    $xml = $nid_v['xml'];
                                                                                                                    
    $doc->loadXML($xml);
    $xpath = new DOMXPath($doc);
    $article = $xpath->query("http://Article");
    $creatorId = $article->item(0)->getAttribute('creatorId');
    $sortOrder = $article->item(0)->getAttribute('sortOrder');
    $createDate = $article->item(0)->getAttribute('createDate');
    $updateDate = $article->item(0)->getAttribute('updateDate');
    $nodeName = $article->item(0)->getAttribute('nodeName');
    $writerName = $article->item(0)->getAttribute('writerName');
    $pageTitle = $xpath->query("http://Article/pageTitle");
    $metaDescription = $xpath->query("http://Article/metaDescription");
    $metaKeywords = $xpath->query("http://Article/metaKeywords");
    $articleTitle = $xpath->query("http://Article/articleTitle");
    $articleImage = $xpath->query("http://Article/articleImage");
    $bodyText = $xpath->query("http://Article/bodyText");
    $articleDate = $xpath->query("http://Article/articleDate");
    $author = $xpath->query("http://Article/author");
    $articleSynopsis = $xpath->query("http://Article/articleSynopsis");
    $articleTags = $xpath->query("http://Article/articleTags");
    $issueNumber = $xpath->query("http://Article/issueNumber");
    $node->title = $articleTitle->item(0)->nodeValue;
    $node->type = 'article';
    $node->uid = 1;
    $node->status = 1;
    $body = $bodyText->item(0)->nodeValue;
    $node->body['und'][0]['value'] = $body;
    $node->body['und'][0]['format'] = 'full_html';
    $p_w_picpathpath = $articleImage->item(0)->nodeValue;
    $img = _test_migrate_create_img($p_w_picpathpath, $debug);
    if (!empty($img)) {
      $node->field_p_w_picpath[LANGUAGE_NONE][] = (array) $img;
    }
    if (!$debug) {
      node_save($node);
    }
    else {
      dsm($node);
    }
  }
  return '';
}
/**
 * Create p_w_picpath by file path.
 * requirement: file entity module.
 *
 * @Return file obj.
 */
function _test_migrate_create_img($imgpath, $debug) {
  if (empty($imgpath)) {
    return 0;
  }
  $filename = str_replace('\\', '/', $imgpath);
  $file->uri = 'private:/' . $imgpath;
  $target_dir = 'public://articles' . dirname($filename);
  if (!file_exists(drupal_realpath($file->uri))) {
    return 0;
  }
  file_prepare_directory($target_dir, FILE_CREATE_DIRECTORY);
  $file->filemime = file_get_mimetype($file->uri);
  $file->status = 1;
  $file->uid = 1;
  $file->type = 'p_w_picpath';
  $file->display = 1;
  if (!$debug) {
    $file = file_copy($file, $target_dir, FILE_EXISTS_REPLACE);
    return $file;
  }
  else {
    dsm($file);
    return 0;
  }
}

新聞標題：Umbraco(asp.netcms)toDrupalmigration
鏈接分享：http://www.yijiale78.com/article16/gjhcgg.html

成都網站建設公司_創新互聯，為您提供外貿建站、虛擬主機、全網營銷推廣、品牌網站制作、網站排名、自適應網站

廣告

聲明：本網站發布的內容（圖片、視頻和文字）以用戶投稿、用戶轉載內容為主，如果涉及侵權請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網站立場，如需處理請聯系客服。電話：028-86922220；郵箱：631063699@qq.com。內容未經允許不得轉載，或轉載時需注明來源： 創新互聯