Home » Archive

Articles in the Tips Scripts Category

ORA-HOWTO, Oracle, Tips Scripts »

[23 Nov 2009 | No Comment | 501 views]

There are lot of ways in which files are copied from one database to the other during database cloning or transporting tablespaces.
File transfers can be done using oracle package called “DBMS_FILE_TRANSFER”.
Let us assume we need to transfer a file x.dbf from database SOURCE_DB to database DEST_DB
Do the following :
AT SOURCE_DB:
==============
1)Create directory source_dir as ‘/u01/dbdata’;
2)Create database link remote_db
connect to system identified by manager
using ‘remmote_db’;
Make sure to add this entry in TNSNAMES.ORA file.
Check if the database link works by
select count(1) from dba_tables@remote_db;
AT DEST_DB:
============
create directory dest_dir as ‘/u02/dbdata’;
Now back to SOURCE_DB:
exec dbms_file_transfer.put_file(‘SOURCE_DIR’,’x.dbf’,’DEST_DIR’,’x.dbf’,’REMOTE_DB’);
Now the …

Administration, MS SqlServer, MS SqlServer Code, Tips Scripts »

[23 Nov 2009 | No Comment | 1,058 views]

These scripts have been created to set up a peer to peer system.
The settings I’ve used:

Login:
PAULSDOMAIN\Administrator

Password:
password

Database name:
peertopeerPublisher

Table with PK:
PITest

Server1
HOME-SERVER

Server2 
HOME-SERVER\FIRSTINSTANCE

You’ll need to create an identically named database on 2 servers (called peertopeerPublisher for me) or on a default and a named instance (this is because the publication names must be identical, so we can’t do this on the same instance). After that you’ll need to enable distribution on each server and publishing of the database. This is much the same as before, albeit in a different part of the GUI. There …