Databases

56K

Solutions

39K

Contributors

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi - I was wondering if someone can advise please. Our organisation uses a ERP systems which has 4000 Relations tables. There is a discussions on creating a master database - where any changes to these tables are populated into Master database. I am worried about this approach - for example, there is no business logic and any changes gets sent to this MD, which is used for integration with other systems? I would have thought you use master database to bring in data from various systems rather than just duplicating one system into another.

The argument for creating a master database is so there is no need for peer to peer integration - I agree peer to peer is not good but thats what what BizTalk is there for. They want to use BizTalk to pull data from the ERP into Master Database and then use SSIS to push data out to other systems. I can't see why they can't they just use BizTalk to transform the data and push the data out. Their other argument if the ERP system ever goes cloud it is not possible to do a full extract (i.e, not delta extract) using SSIS - but the issue nobody even know if we will ever even go hosted solution for the ERP we have. Additionally, even in such a case if there is a good business case I am sure the cloud prvoide will let SSIS access directly to database on the hosted cloud. Do you agree? Can you give your inputs on the flaws with this approach or is it just me worrying?

Thank you.
0
Introducing Cloud Class® training courses
LVL 12
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Trying to fetch ID in response that is stored in database of Post request. In table ID is autogenerated. tried one code but it is not working. Please suggest.

    public HttpResponseMessage Post(List<DelegateTable> delegatetable)
        {
            try
            {
                using (ShowContext delegateContext = new ShowContext())
                {
                    DelegateTable delegates = new DelegateTable();
                    List<DelegateTable> list1 = new List<DelegateTable>();
                  
                    foreach (DelegateTable item in delegatetable)
                    {
                       
                        delegates.Salutation__c = item.Salutation__c;
                        delegates.First_Name__c = item.First_Name__c;
                        delegates.Last_Name__c = item.Last_Name__c;
                        delegates.Account_Name__c = item.Account_Name__c;
                        delegates.Contact_Email__c = item.Contact_Email__c;
                        delegates.Category__c = item.Category__c;
                        delegates.Conference_Type__c = item.Conference_Type__c;
                        delegates.Conference_Selection__c = item.Conference_Selection__c;
                        delegates.Payment_Status_Interface__c = item.Payment_Status_Interface__c;
                        delegates.Barcode__c = item.Barcode__c;
                        delegateContext.delegates.Add(delegates);
                       
            

Open in new window

0
Hi Expert,
I have question for MS SQL Server 2012 Experts DBA’s or Developers. I have been tasked recently to Created new SQL Instance on production Server and import or Copy the Existing SQL Data bases to new instance. The Scenario is, we have very critical Application e.g. “CRITICAL”, Application Server 2012 and MS SQL Server 2012 Instance for this application running in production environment. The project initiated by relevant department to upgrade the Application. With latest versions involving Application vendor and as requirement. I have built the new Application Server which done but there is requirement to create new SQL instance as well so they can test  and UAT purpose before bring this into production.
There is no problem to Create new SQL Server instance and backup all the existing Data base on production Server.
Question: how I have copy or import existing Data base from existing instance with all structure in New SQL server Instance, and what will be impact copying production database on new instance. Is this will not break the conflict with existing database and cause an issue with application?

Regards
A
0
DBMS and RDBMS

I did some online reading, where it stated that:

<<The key difference is that RDBMS (relational database management system) applications store data in a tabular form, while DBMS applications store data as files. Does that mean there are no tables in a DBMS? There can be, but there will be no “relation” between the tables, like in a RDBMS>>

*** so how can you make a query fetch several pieces of Data from different files in DBMS

SQLLite if I am correct is DBMS rather than RDBMS

what are other DBMS Databases and RDBMS?

THank you
0
I have a failed SQL backup and have no clue why this is happening? Can anyone help with this?

Failed:(-1073548784) Executing the query "BACKUP DATABASE [JDE910] TO  DISK = N'\\\\x.x.x.x..." failed with the following error: "Cannot open backup device '\\\\x.x.x.x\\JDE Images\\SQL Backup\\Daily\\JDE910_backup_2018_07_14_220001_8461617.bak'. Operating system error 1311(There are currently no logon servers available to service the logon request.).
BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.


X.X.X.X are the IP address of the webserver jde
x.x.x.x is the ip address of the NAS device where the backup has to be moved
0
Hi,

Anyone can advice the attached error. Tks.
move_error1.jpg
0
So i have a user schema like this:

var user_schema = new Schema({
   username:{type:String,required: true, unique : true, trim: true},
   college:{type:String,required: true},
   password:{type:String,required: true, trim: true},
   email:{type:String,required: true, unique : true, trim: true},
   phone:{type:Number,required: true, unique : true, trim: true},
   dp:{type:String},
   tag:{type:String},
   description:{type:String},
   friends:[{type:String}],
   pending:[{type:String}],
   skills:{type:String},
   bucket:[{type:String}]
  });

Open in new window

and my objective is, to search the all the documents in the collection to get people based on the following conditions:

1. They should not be in the users' "friends" array.
2. They should not be in the users' "pending" array.
3. They should have the same "tag" (a string value) as the user.

So, basically I have to compare the users' fields ("friends","pending" and "tags"), with fields of all documents in the whole collection.

How do I do it, using mongoose (nodejs mongodb library)
0
Hi,

im curious if there is a way to do the following in PHP but within a stored procedure with SQL on the fly

$managers = array(
	0 => array(
		"id"	=> 1,
		"name"  => "manager",
		"email"	=> "email"
	)
	...
)

foreach($managers AS $d){
	//send mail
	mail(...);
	
	//Insert into messages table
	INSERT INTO...

}

Open in new window


Essentially, i would want to SELECT the manager from a table and then immediately insert it a message into the massage table

for example:

1. select manager 1
2. insert message into message table for manager 1
3. repeat for manager 2
,...so on

I would handle sending the email using php

I KNOW i can do this in a few steps such as
1. Select all the managers and organize them into an array to loop over
2. loop over the managers and create an array of emails as well as sql statements i can create a transaction with and submit the inserts all at once
3. complete loop
4. send the transaction to sql
5. send the email

but i am curious if i can do it one for one within a stored procedure

Thanks in advance
0
I have an access database that I am converting to a vb.net project.  There are a few lines of script that are causing issues.  Mostly the DLookup conversion.  Any help at converting this script would be most appreciated.  Thank you in advance!

Here is the original VBA code:

Private Sub Form_Timer()
'On Error GoTo ErrTrap:
    Dim DB As Database
    Dim rs As Recordset
    Dim count As Integer
    Dim displayCount As Integer
    Dim formToOpen As String
    Dim stopTime As Date
    Dim nowTime As Date
    Dim WinWnd As Long
   
    'Determine if a member of management has set an alert message. If not, continue normal operations
    If DLookup("Alert", "AlertMessage", "Alert > 0") <> "" Then
       
        'Open the alert message
        DoCmd.OpenForm ("frmMessage")
       
    Else
   
        Call Form_Query
       
        ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
       
        'Run the NRFT screen for 1 minute, then open the safety message
        If runCount = 2 Then
            DoCmd.OpenForm ("Form1")
        End If
       
        'Close the safety message after 1 minute
        If runCount = 5 Then
            DoCmd.Close acForm, "Form1"
        End If
       

           
        If runCount >= 8 Then
       
       
            'Loop through all rows in the Content table where Active is set to yes
            'For Count = 0 To DCount("Active", "Content", …
0
Hi

This is how query looks like:
First query:

select FullName, SystemUserId from SystemUser
ORDER BY FullName

This query will show 100x systemuserID now to the next one:

update UserEntityUISettingsBase
set RecentlyViewedXml = null
where OwnerId = 'SystemuserID'

ok here comes the question, how do I do this easiest? Declare a var for 100 systemuserID? how do i do this so the 100x systemuserID updates easiest.

Thanks
0
Upgrade your Question Security!
LVL 12
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

We are randomly having issues with our barracuda backup of our SQL 2014 DB's. It will run for weeks and then get this error for several days. Sometimes a reboot works, other times it does not.
here is the application event id info:
 System

  - Provider

   [ Name]  SQLWRITER
 
  - EventID 24583

   [ Qualifiers]  0
 
   Level 2
 
   Task 0
 
   Keywords 0x80000000000000
 
  - TimeCreated

   [ SystemTime]  2018-07-13T02:03:27.000000000Z
 
   EventRecordID 79638946
 
   Channel Application
 
   Computer SQL2014.AbleHC.local
 
   Security
 

- EventData

   ICommandText::Execute
   0x80040e14
   SQLSTATE: 42000, Native Error: 3013 Error state: 1, Severity: 16 Source: Microsoft SQL Server Native Client 11.0 Error message: BACKUP DATABASE is terminating abnormally. SQLSTATE: 42000, Native Error: 3271 Error state: 1, Severity: 16 Source: Microsoft SQL Server Native Client 11.0 Error message: A nonrecoverable I/O error occurred on file "{9259D979-BF0D-4316-AAC5-29F290E39625}5:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).
0
In oracle how can I replace the chinese character from a given string
string = '020?Domestic CT outgoing?20测试叙事测试叙事 测试叙事测试叙事测试叙事 ?21测试叙事测试叙事)测试叙事测试叙事测试叙事?31测试叙事测试叙事 测试叙事?32测试叙事'

I want the Output as
020?Domestic CT outgoing?20:?21:?31:?32

Please help me
0
I would like to use VBA to change the color theme of the Access application I have created. I actually use the database when I am at work, along with other employees within the company. I have code that switches between the live data and my development data. As part of that switch, I would like to change the color theme when I am in development mode so that I always know when I am using the development data and when am using live data. I have looked around on the online groups and don't find anything that lets me change the color theme and not just change the colors on a single form or report. If this is not doable, does anyone have another suggestion on how I can make it obvious when I am using the live data and when I am in development mode?
Thanks,
Kim
0
Can anyone advice if I want to moving the user mailbox from this DBTemp has 574 users mailbox to the differnet DB1 & DB2.

Moving 292 users mailbox to TRANS2 DB1
Moving 282 users mailbox to BUS DB2

Tks.
0
I have to initialize an array to [](empty array) and then push user chose "tags" into it. This is my schema:

 var user_schema = new Schema({
   username:{type:String,required: true, unique : true, trim: true},
   college:{type:String,required: true},
   password:{type:String,required: true, trim: true},
   email:{type:String,required: true, unique : true, trim: true},
   phone:{type:Number,required: true, unique : true, trim: true},
   dp:{type:String},
   tags:[{type:String}],
   description:{type:String},
   skills:{type:String},
   bucket:[{type:String}]
 }); 

Open in new window

` and i have to initialize "tags" to [] and push user string values (user entered/chosen) every time the request is made to the API call.

I am using this line of code:

 stu_user.findOneAndUpdate(
   { _id: req.decoded.id },
   { $set:{tags:[]},$push: { tags: 'some chosen string'  } },
  function (error, success) {
         if (error) {
            console.log(error);
        } else {
            console.log(success);
        }
    });

Open in new window

But it's not working.
0
can I connect mysql workbench to two normal desktop or laptop computer
0
i have several postgres databases in my ubuntu servers. how to create master/slave from only "one" database. not all.
0
Hi Experts,

Is there any way to compare 2 timestamp and pull records from DB2 using query.

 Query wil be having input file which contains basic timestamp .We have to compare this timestamp with the timestamp in process_date column and have to pull all records which happend after this basic timestamp.

How to compare timestamps and pull records ...

Any help regarding this would be helpful.

Thanks in Advance.
0
Hello Experts,
After moving users mailboxes from old mailboxdatabase to new mailboxdatabase, dismounted the Mailboxdatabase and while deleting the Mailboxdatabase from active server, getting below error message.

Can move the HealthMailboxes from old Mailboxdatabase to new Mailboxdatabase?

[Or]

Delete the HealthMailboxes associated with old mailboxdatabase users from Monitoring ADUC container?

This is the message i received in Mailbox Server.
 -----------------------------------------------
 WARNING: Failed to remove monitoring mailbox object of database "MBX_Server_EDC_1_Remove". Exception: Active Directory
 operation failed on EX-DC01.Domain.com. This error is not retriable. Additional information: Access is
 denied.
 Active directory response: 00000005: SecErr: DSID-03152501, problem 4003 (INSUFF_ACCESS_RIGHTS), data 0

 ----------------------------------------------
Your help must be appreciated.

Thanks-Sami
0
Ultimate Tool Kit for Technology Solution Provider
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Python forms for Database programming.

In other programming languages, programmers use forms to drop labels, buttons, textboxes, drop down arrows,etc....they also create links to the database from the form.
programmers will write code for the Events created, for instance when user click on a button, or tabs to another textbox,etc....
I wonder what type of forms that Python use to achieve similar goal.

Thank you
0
Dear expert,

Simple query, I want MSSQL to exclude all the NULL result in columns from the table.

Any easy solution?
Thx
0
Hi

I have a database which is used to keep track of industrial objects for a project. For each record (object) there are a connecting revision table (one to many) which is utilized to keep track of data changes for the object (revision handeling).

Data structure:
-Main Table
*Revision Table

The interface is a split form with a subdatasheet form for the revision handeling. I want the user to have the possibility to work in both views (form view and datasheet view).

Now to the issue, when deleting or copying records in the subdatasheet form I get the notification "This Operation is not supported within transactions" and the operation is not carried out (even if it looks like the records are deleted).
When directly in datasheet view for the main form this problem does not occur.

I have made a video of the issue
0
I'm new to mysql and need some help. I have populated a multi-select drop down with my first query. The dropdown populated correctly and I want to use the value or values from the dropdown to get results from a second query. I will try to explain some more.

I have a multi select dropdown named students that is populated with Names and values that are numbers. I want to select one, two or all and use those values in a second query. The dropdown will have values like 390, 234, 5421, 461. If you look at the query below you will see the student_id = 461 that value is what I want to get from the dropdown. This query works if I place in the student_id.

SELECT *, student_id, SUM(handled) FROM stats WHERE student_id = 461

From there I
echo "Handled: " . $row["SUM(handled)"]. "";
and that works just fine.

Thanks for any help.
0
Hi,
I have wordpress site that we use to sent out emails to users about different stuffs, information etc..
Users instead of logging in and replying on the sites, replies directly from the mail server.
How can I set it up such that once the first email is sent, the email conversation between user and admins can happen on the email itself but the messages get recorded in the database with the appropriate reference /tags.
0
Need a way to programmatically close an MS Access database and programmatically open another.

Each user has an MS Access application that I call MyProgram.mde on the workstation local hard drive (10 users).

Each time I roll out a new version MyProgram.mde all I need to do is copy the new version to a network drive.

The users start MyProgram.mde each day by clicking a shortcut to another program called BootStrapLoader, which is also on the local drive.

When BootStrapLoader starts, it compares two fields, on in each version of MyProgram, to determine whether the code on the network drive is a higher version number.

When it finds a higher version number on the network drive, it copies that version of MyProgram.mde to the local drive, overwriting the old version.
Then, after a delay that I add to allow for the file to copy, BootStrapLoader closes and also starts MyProgram.mde.

When the copy on the network drive is the same version, BootStrapLoader closes and then starts the program on the local drive.

To accomplish this, I have been using a program called TsiSoon90.dll, which is something that someone on this forum told me about many years ago, and has worked very well on our XP machines.

We are now upgrading to 64-bit Win7 and Win10 machines, and the 32-bit version of TSIsoon90.dll does not register.  I suspect this a 32 vs 64 bit issue.

Does anyone know how to get this to work on Win7 or Win10 64-bit machines, or have another solution?

I would …
0

Databases

56K

Solutions

39K

Contributors

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.