• Value too Long in Microsoft Access

    this is a hypethetical question.. Using MS Access you enter the last name of a student, and you recieve an error message stating that the value is too long for the field. What are your next steps?

    Jeffhill5 pointsBadges:
  • Converting the XML data into SQL table and how to move values to a CLOB variable.

    Can anybody explain with an example for converting the XML data into SQL table and how to move values to a CLOB variable. Because I've looked at lot of sites but still not getting a proper solution.

    Sasikumarr200 pointsBadges:
  • Stress test a NAS system for a database

    I'm trying to stress test a NAS system for my database. I'm looking to see how much abuse the system can take and how it will affect the database performance. Here's what we have planned so far: Copying very large amounts of Data onto and off of the device (at the same time). Using the SQLIOSim...

    ITKE372,450 pointsBadges:
  • NoSQL Database(s)

    I am knew to this tech. I understand NoSQL is not relational. Could old COBOL file structures or such systems be considered as NoSQL type since we could put different record structures with variable lengths (dependent on array values) and we could design a UI as a record (incorporating arrays as...

    Chegutu465 pointsBadges:
  • Backup and replicate SQL Server database

    We have a SQL Server database that contains our most recent data. We need to replicate the content into several other servers. But for some reason, we can't use the replicate / sync function to sync to other SQL Server instances. What would be the best way to do this? Thank you!

    ITKE372,450 pointsBadges:
  • Clustered index on view


    debadarshsn5 pointsBadges:
  • Handle MySQL backups with Git

    For our MySQL backup, we came up with a pretty good idea but we're not entirely sure. To backup it up, we thought of putting the dump file into a Git repository, and the commit on each dump so we have the most recent copy / we can roll back to a previous backup. But we're not sure of the flaws...

    ITKE372,450 pointsBadges:
  • How to do MySQL backups on a budget

    Our MySQL backup strategy is to replicate our database to a second server and then run mysqldump on that server to get rid of any downtime from table locking. It's working great but the cost is huge (Over $150 per month on that second server). Anyone know of another way to do MySQL backups cheaper?...

    ITKE372,450 pointsBadges:
  • Setting up a database server in-house

    Goal: add a database server for silo storage environment to meet client requirements. Send queried reports from shared SQL server to new database server to be accessed from website dashboards. What is the best server set up to accomplish this?

    SacredGrounds5 pointsBadges:
  • Best way to backup our production database

    For the past several weeks, we've been looking at CouchDB for a CMS application. What's the best way for us for backing up our production database? Should we possibly clone the database (so we can use it in testing / development). What about just copying the files on a disk? Thanks for the help!

    ITKE372,450 pointsBadges:
  • How to insert row number using SQL

    When importing data from Excel into MS Access, how do you insert a row number using SQL?

    JimStAubin201515 pointsBadges:
  • Performance issue with MySQL database backup

    My friend and I have been trying to create a regular backup for a production database (large one, in fact). The database has both InnoDB and MyISAM tables. We have been using mysqldump but it keeps taking longer and longer each time. Sometimes, the server is even unresponsive when the dump is...

    ITKE372,450 pointsBadges:
  • Backup SQLite database to SD card on Android

    I'm trying to add a feature to one of my Android applications that would back up a SQLite database to my SD card. Is there a way to do this? Thank you very much!

    ITKE372,450 pointsBadges:
  • Add New Record in database form

    The form in my database will not allow me to add a record - the record functions are grayed out. I was able to add a new record. Then I was not. Probably user error, but not sure what to do.

    jsuddath5 pointsBadges:
  • How to restore single table my MySQL database backup

    We currently have a mysqldump that backups our MySQL database (which has a bunch of tables with roughly 440 MBs). We've been trying to restore one of the tables from the mysqldump. Would that be possible? Thanks so much!

    ITKE372,450 pointsBadges:
  • How to backup SQLite database to SD card

    Does anyone know if it's possible to backup our database to a SD card automatically in my Android app? After that's done, is there a way to restore it too?

    ITKE372,450 pointsBadges:
  • How can I backup a SQLite database to my SD card?

    I'm trying to add a feature in my Android application that would automatically back up a SQLite database to my SD card. Is there a way to do this? Thank you very much.

    ITKE372,450 pointsBadges:
  • SQL Script for monitoring backup progress of database

    I noticed that whenever I do a backup of a database using SQL Server Management Studio, I usually get this image of how the process is going / how much longer it will take. But if I do the backup with a script, is there some way I can monitor the whole process?

    ITKE372,450 pointsBadges:
  • Import and Export data from AS/400 using ODBC

    I imported data from AS/400 database file into an Excel sheet, using ODBC. I selected Microsoft query in order to retrieve data. How can I export data into AS/400 database file?

    Geek51180 pointsBadges:
  • How to automate SQL Server database backup

    I've been generating SQL Scripts on a daily basis so we can have a backup our SQL Azure database. But we're working to do this on an automated level. Is there a way to do this?

    ITKE372,450 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.