Tag Info

New answers tagged

-1

It would be time saving if you just backup the tables being errored in ORA-1555 after the warning full backups. Yes, to answer main question, it is good backup to be imported, you can exclude the errored tables or use table_exists_action=replace using tables only backup after taking the tables backup in above para. Scenario warning = if the errored ...


1

Technically, you could, but it is incomplete, so better repeat the export after performing the necessary actions to avoid ORA-01555 errors (have an appropriately sized undo tablespace, set undo_retention and retention guarantee).


3

Yes, stay away from the sp_OA* OLE Automation procedures. If you want / need to handle this purely within SQL Server then you can do so using SQLCLR, which replaces the sp_OA* OLE Automation procedures. And if you aren't using xp_cmdshell for anything else, then no need to enable it just for this (although to be fair, if using SQL Agent, then a CMD step ...


0

I do that using xp_cmdshell. You can export data from SQL job and then you can zip using that stored procedure. The best way is to run a bat file for zip. REMARK: to use that sp you need that it is allowed (on SQL Server level) and you must have permissions to run it.


1

You should have him send you a public gpg key that he has the private key for, which you use to encrypt the dump. You can then deliver it to him using any method that is comfortable for you, and then he can decrypt it once he has received it. If you're on Windows.. http://www.gpg4win.org/ is a great tool for that.


2

Of course you can put it up on Dropbox - or anywhere else. Depends on how secure you want your data to be? Do you want the NSA looking at it? Dropbox employees? I would put up an encrypted version of your mysqldump and securely transmit the key to your colleague - either face to face or over encrypted email, or have the password/key sent by courrier. ...


0

Looking for an application that can help you easily migrate your MS Access database to MySQL without having to follow any tedious procedure? Transferring databases from one system to another is always a headache regardless of how big or small the database is. Therefore, database managers and administrators look out for a simple tool that can perform an ...


0

You can use ODBC to connect from MSAccess to MySQL. Here is an example. What you should actually do is: Configure a new ODBC DNS connection (this might help) Inside access - click on the table you would like to export, click on the file menu, then go to export and choose the name for the export Select the ODBC connection you just created from the list of ...


0

For me @VĂ©race's answer didn't maintain the column names, but assigned default names (f1, f2, etc.) instead. I am using PostgreSQL 9.1 with the JSON extension. If you want to export the entire table, there is no need for a subquery. In addition, this will maintain the column names. I used the folowing query: COPY (SELECT row_to_json(t) FROM fred as t) to ...


2

The paths in the generated script are the locations where the data and log files should be on your laptop. If you copy paste the script to amazon AWS that will be the location where the files are created when you create the database. If that path doesn't exist on the Amazon instance you will get errors. You could comment out the lines and then the files ...



Top 50 recent answers are included