copy one database info to another ?

[jayender.vs]

Hello People,
i need to know how to copy one database to another..
say i got one database in which i stored some data and i need that data to be copied to another database.
how to do that?

[bigBA]

simplest way would be to dump your data from db 1 and import it into db 2.

[Norby mahoney]

Yea, you have 2 options ( that I can think of)
1.) Source Database: Export the data in a form that can be imported into the Target Database.
2.) Using a tool ( like Enterprise Manager for SQL Server), directly import the data from the Source Database ( and skip the export (dump) step ).

It might help if you provide a little more info, like which databases are involved here.

[jayender.vs]

Hi,
OK !! i will give you some more info ..

i got one database pxris (name of the database) where i have stored all the information.

i have taken a backup of this database (backup is stored in another system)

now i need to retrive that database.

here is the requirement comes ....

i need to restore (retrive) the database to a new database : means i need all the information that i stored in pxris to be copied inmy new database.


howto do it?

please help me ...

[Norby mahoney]

Never heard of this database; I did a Google search and found nothing either.
Are you using ADO? If so, and their is an OLDEDB provider for this database, then have a look at ADOX.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/admscadoapireference.asp

[cristane]

Uhhh... I have the same problem.

I need to copy all data from all tables from one database to another.

My problem is I cannot use the EXPORT command because it requires all connections to the database to be ended. And I cannot afford that, not even for one second.

So i was thinking to make a select in all tables, redirect the output to some text files and insert the results in my new database (whose structure I already created).

But I was thinking..... is there any other simpler way to do this?

Thank you.