use sourcedatabase; var docs=db.sourcetable.find(); use targetdatabase; docs.forEach(function(doc) { db.targettable.insert(doc); }); ESTA ES MÁS RÁPIDA (FASTEST!) db.sourcecollection.aggregate([{$out : «targetcollection»}]);
An older version of this article was written by Dean Attali. Introduction While many people primarily turn to the open-source programming language R for statistical and graphics applications, Shiny is an R package that allows you to convert your R code into interactive webpages. And when combined with Shiny Server — available in both a… Leer más: How to Set Up Shiny Server nginx »
Shiny Server is a web server program specifically designed to host R-powered Shiny apps. With Shiny Server, you can easily host various R-powered apps without getting HTML, CSS, JavaScript or other stuff involved. This article will guide you through the process of installing Shiny Server on a CentOS 7. Prerequisites A VM Running CentOS 7… Leer más: How to Install Shiny Server on CentOS 7 »
Environment Product: Progress Version: 9.1x Product: OpenEdge Version: 10.x OS: Windows Other: Crystal Reports Question/Problem Description How to avoid setting the pub qualifier before each table name in a Crystal Report ? How to set the pub qualifier in Windows registry? How to use existing SQL-89 Crystal Reports with SQL-92 ? How to set the… Leer más: How to set the PUB qualifier in the Windows registry… »
First download dbfpy: http://sourceforge.net/projects/dbfpy/files/latest/download?source=files Then install: sudo python setup.py install To convert DBF file to CSV: ./dbf2csv database.dbf #!/usr/bin/python import csv from dbfpy import dbf import os import sys filename = sys.argv[1] if filename.endswith(‘.dbf’): print «Converting %s to csv» % filename csv_fn = filename[:-4]+ «.csv» with open(csv_fn,’wb’) as csvfile: in_db = dbf.Dbf(filename) out_csv = csv.writer(csvfile)… Leer más: Python script to convert DBF database file to CSV »
https://csvkit.readthedocs.io/en/0.9.0/ About csvkit is a suite of utilities for converting to and working with CSV, the king of tabular file formats. It is inspired by pdftk, gdal and the original csvcut utility by Joe Germuska and Aaron Bycoffe. Input in2csv sql2csv Processing csvclean csvcut csvgrep csvjoin csvsort csvstack Output (and Analysis) csvformat csvjson… Leer más: csvkit 0.9.0 (beta) »
PostedApril 15, 2016 91.2k views MongoDB Backups Ubuntu MongoDB is one of the most popular NoSQL database engines. It is famous for being scalable, powerful, reliable and easy to use. In this article we’ll show you how to back up, restore, and migrate your MongoDB databases. Importing and exporting a database means dealing with data… Leer más: How To Back Up, Restore, and Migrate a MongoDB Database »
Introduction A typical Linux server deployed from a ProfitBricks supplied image has a single storage volume, /dev/vda. If we take a look at that using fdisk we will see that the disk is divided into two partitions. The first one, /dev/vda1, is the boot partition where the OS resides. The second partition, /dev/vda2, is configured as swap space. root@debian:~# fdisk… Leer más: Resize a Linux Root Partition Without Rebooting resize alienvault »
How to connect progress jdbc:datadirect:openedge://192.168.1.1:13000;databaseName=dbname[-mdbq:listadb];defaultSchema=pub com.ddtek.jdbc.openedge.OpenEdgeDriver C:\Progress11\OpenEdge\java\openedge.jar Fix width progress sql dbtool dbname
TOP clause Limits the rows returned by an OpenEdge SQL query at the statement level and is supported in subqueries. Syntax TOP n[ column_name [, column_name ] …..| * ] Parameters n Indicates the number of records per table. [ column_name [, column_name ] …..| * ] Indicates the columns within a table. When the… Leer más: TOP clause progress (Limit sql) »