copying data from one database to another database

tenchi96

I working on a little script i can run to copy Certain tables from one database to another database can anyone give me a heads up on how to do this

Sxooter

This tends to depend very much on the database engine you're working on and if you have access to the command line tools for said database or not (i.e. are you running PHP in safe more or not).

If you're NOT running in safe more and you ARE running PostgreSQL, it's as easy as:

pg_dump dbname -t tablename|psql otherdbname

dump with a -s script to dump only the schema .

Something similar can be done with MySQL, but I'm not that familiar with the dump tools there.

tenchi96

I'm Running PHP5 not in safe mode, MSSQL 7.0 and IIS5

Sxooter

Wow, that is VERY outside the field of my experience. I wonder what kind of SQL statements can be used to explore the schema of a MSSQL server... Or if suitable command like utils could be called.

AstroTeg

With MS SQL, you can use the command prompt command "isql" which is able to do some great importing and exporting tricks. I don't have the useage info for isql, but you can probably find that out on the 'net or if you try running it or do isql /?. You may need to try finding it on your computer or the MS SQL server. It may not be installed by default. I believe you'll find it on the MS SQL utilities CD.

Sxooter

Note that if you KNOW how the tables are put together then it's a simple matter of opening two connections, one to each database, and reading one row from one and writing it to the other as you go along.