oracle database impdp command issue

I have two oracle database “orcl” and “orcl1” and each database i have two schemas( hr&log ) in the two databases with the same schema name . Now i have two tables table := A AND table := B . These tables are present in the database “orcl”
in “HR” schema ,i want to import the data of the tables(A,B) from hr schema in orcl database to “log schema ” in orcl1 database.Here i have created the structure of the tables (A & B) in hr schema in orcl1 database. When i use impdp command it is throwing error.

impdp hr/user@orcl1 tables=a,b directory=sys dumpfilename=a_b.dmp logfile=a_b.log

“table or object not found”

I have created both the objects in the orcl1 database and given necessary grants to the tables like select,insert to public

Can any one suggest me and approach .

Thank you.

Database design – how to define entities for matrix-based user-data

I am developing an application where exists an application user. For the current moment, application user must be either ‘company representative’ or ‘individual entrepreneur’ by juridical status. In the same time, user must be either ‘service-requester’ or ‘service-provider’ by the role in the application. During the registration process, depending on role AND juridical status, user asked to provide an information about himself.

So here I enumerated all possible user statuses – { service-provider company representative, service-provider individual entrepreneur, service-requester company representative, service-requester individual entrepreneur }.

Depending on the status of the user, data (information) asked during the registration process MAY be different in future.

I thought about creating 4 different tables, as in the attached picture. Is it the right approach?

Current design

I need a word database… Any qualities I should look for?

I need a word database to train from. I found a word2vec JS word vector database, but I need a method to teach it which words go in which patterns.

Please note that I am not asking to have you recommend a database, just asking for some qualities that I should look for in a database.

I want it to be able to run at a notice, and not take 10-ish minutes to set up.

I am using Word2Vec word vectors, provided in JSON form by Anthony Liu. I am using the 1000 word list.

TL;DR

What are some qualities I should look for in a word database to train from?

Online migration using Database Migration Services

I wanted to test online migration to azure sql db using azure database migration services. I am following the below link.
https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-azure-sql-online

But in step 7 under “Create Migration project”, I am unable to see online data migration under activity. I have DMS in Central US location.

enter image description here

Anybody had the same issue?

Embedded database with bulk insert feature and it can handle 2.5 millions of records

I am exploring embedded database from one of my upcoming projects which should be working with c#.

Requirement:

  1. There is one text file with row and column delimiter to separate the column and row separator
  2. I have to read that file and separate rows and columns with the delimiter and import into an embedded database with an appropriate data type.
  3. There should be bulk insert functionality for import into database otherwise insert operation will take too much time for 2.5 million records.

For this requirement, I have explored below embedded database and stuck on limitation.

SQLite, Firebird

  • I have explored so many embedded databases and found this 2 as good.
  • I found below limitation in it: No bulk insert support provided so it is taking too much time to insert only 100,000 records because first I am fetching data from text file and insert records in SQLite and Firebird so it is a very time-consuming process as there isn’t any bulk insert feature.

SQL Server Compact Edition 4.0

  • This is also a good one and also we can handle bulk insert using SQL server Compact Bulk Insert

  • But the issue is like there is a limitation of 4 GB of database size and it is fully occupied with 5000 rows and 100 nvarchar(2000) column.

So can anyone please help me with this?

Rest api or direct database? Ajax or curl?

What I want is to display data from mysql database based on inputs from form. The website is live at http://condense.press/ Which of the following is a good and simple architecture.

  • Directly interaction with database and displaying in iframe. This one
    is currently done at https://github.com/agnelvishal/Condense.press
  • Directly interaction with database and displaying with ajax. This is done at https://github.com/agnelvishal/Condense.press/pull/22
  • Using curl to
    call rest api which interacts with database. This is done at https://github.com/agnelvishal/Condense.press/pull/24
  • Using ajax and rest api.
  • Using frontend frameworks like vue or angular.

Separate SQL Server or just separate SQL Database for test and production?

I’m new to SQL Server, so this may be more of a SQL Server management question.

I’m creating test and production databases for a service, and I imagine I’ll be wiping the test database quite a lot. Additionally, I’m going to want different replication and audit logging strategies.

Does it make sense to have both SQL Databases on the same SQL Server, which seems to be what the Azure Portal makes easiest to manage, or does it make more sense to create a separate logical SQL Server for the test and production databases?

Is ETL/script the best way to create SQL database from SF?

At our organization we would like to set up a SQL copy of our Salesforce instance for two reasons:

1) the app we are using in Salesforce is shutting down (Common Ground) and we we want to keep a usable archive

2) we would like to run reports that integrate with out other SQL databases.

We do not require real-time data and we want data to flow one-way: Salesforce -> SQL.

We wrote a ruby script which takes the .zip file of Salesforce’s Data Export and iterates over the .csv files inside and creates SQL tables from each of them. However, it has proven difficult to recreate the foreign key relationships in SQL.

For ETL, we have a license for Clover ETL which we have used for some time and we are contemplating the idea of replacing the script with a massive Clover graph. This option would be a bit ugly as Clover doesn’t appear to like processing a multitude of CSV files in different formats.

As I search I am not finding evidence that others use the Salesforce weekly data export for creating a SQL database and most mirror with something like DBAmp, Capstorm, Informatica, etc. Is it a bad idea for us to try and create our SQL database from data exports? Should we instead be purchasing a Salesforce mirroring tool? We are non-profit and free always is accepted.