•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 391,769 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,191 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser:
Views: 417 | Replies: 8 | Solved
 |
•
•
Join Date: Mar 2008
Posts: 178
Reputation: 
Rep Power: 1
Solved Threads: 16
Junior Poster
I have been trying to figure this out, surf thru google but I came back empty handed... I wana move data from Database A to Database B that means copying the content of one database to another database, I am using SQL server 2005... any help will be highly appreciated
Some people get so rich they lose all respect for humanity. That's how rich I want to be.
•
•
Join Date: Dec 2004
Location: London or Slovakia
Posts: 2,137
Reputation:
Rep Power: 10
Solved Threads: 257
Are you planning to do this once in while or this is non-stop requirement
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
•
•
Join Date: Mar 2008
Posts: 178
Reputation:
Rep Power: 1
Solved Threads: 16
Junior Poster
Once in a while, I have been asked to copy database objects including everything in it to another database
Some people get so rich they lose all respect for humanity. That's how rich I want to be.
•
•
Join Date: Dec 2004
Location: London or Slovakia
Posts: 2,137
Reputation:
Rep Power: 10
Solved Threads: 257
What DB you will be using MySQL, MS SQL, Oracle?
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
•
•
Join Date: Mar 2008
Posts: 178
Reputation:
Rep Power: 1
Solved Threads: 16
Junior Poster
Its MySql.... SQL server 2005
Some people get so rich they lose all respect for humanity. That's how rich I want to be.
•
•
Join Date: Dec 2004
Location: London or Slovakia
Posts: 2,137
Reputation:
Rep Power: 10
Solved Threads: 257
Ehmm you trying to get data from MySQL to Microsoft SQL Server 2005?
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
•
•
Join Date: Mar 2008
Posts: 178
Reputation:
Rep Power: 1
Solved Threads: 16
Junior Poster
No Im copying them from the same environment, I need to retrieve some of the data from another database to another, to explain further... I have a database which is Data1 and another database which is Data2, they both in the same environment which SQL Server 2005 so I wana get data from Data1 to Data2....Hope Im clear
Some people get so rich they lose all respect for humanity. That's how rich I want to be.
•
•
Join Date: Dec 2004
Location: London or Slovakia
Posts: 2,137
Reputation:
Rep Power: 10
Solved Threads: 257
Then SQL Server Management Studio Express is your solution. Simply create back up of DB1, then create DB2 and restore data from DB1 there
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Database Design Marketplace
Linear Mode
Other Threads in the Database Design Forum
- Previous Thread: Get first number from query into new form
- Next Thread: What is dis-advantages of auto-increment pk
