Tag Info

Hot answers tagged

10

Don't just use the whole table. Instead choose the option to write a query. Then simply write a select statement that doesn't use that Identity Column. Alternatively, when you map columns, if you click "Delete rows in destination table", it will truncate the target table before loading data. If the opportunity exists for data to be removed from the ...


4

There is only one REMAP_TABLESPACE parameter in de command. It would be seperated with ",". REMAP_TABLESPACE=OLD_SCHEMA_DAT:NEW_SCHEMA_DAT,OLD_SCHEMA_IDX:NEW_SCHEMA_IDX Oracle doc impdp 11.2 http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_import.htm#SUTIL929


2

mysqldump, or .sql files, which is what that module uses is probably the least efficient way to import a database (the only less efficient way I can think of is to import and commit each row at once). If you want to speedup the import process, you should change the method. There are several things that you can do in the MySQL configuration that will speed ...


2

Below is a SQL Table-Valued Function that I got from Jeff Moden, that will return the File Attributes of a single file: /* Return File Attributes about a single file. WARNING: Uses the sp_OACreate method, which should be SA use only. (Note: much of this is copied from Jeff Moden's routines) TEST: SELECT * FROM pps.fnFileInfo('C:\install.exe') */ ...


1

You can use Microsoft Access' built-in import features to import data from just about any source. For Access 2007, the "ribbon" menu has an "External Data" tab, where you can select "Text". From there it is pretty simple to import text-based data. As you can see from the screenshot, there are a number of other types of data you can import.



Only top voted, non community-wiki answers of a minimum length are eligible