•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 403,105 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,189 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 MS SQL advertiser: Programming Forums
Views: 8471 | Replies: 4
 |
•
•
Join Date: Jul 2005
Posts: 6
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
i was wondering how can database replication on a sql server be accomplished?
•
•
Join Date: Feb 2005
Posts: 175
Reputation:
Rep Power: 4
Solved Threads: 5
Junior Poster
•
•
•
•
Originally Posted by Shulc
i was wondering how can database replication on a sql server be accomplished?
Do you mean,You want to create a copy of an existing database?
Save White Tiger
•
•
Join Date: Jul 2005
Posts: 6
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
in short words, yes
•
•
Join Date: Feb 2005
Posts: 175
Reputation:
Rep Power: 4
Solved Threads: 5
Junior Poster
1.Go to Enterprise Manager and right click the databases and create a new database
2.Right click the database which you created and select the ALL Tasks and then select IMPORT DATA
3.Now you should see DTS Import/Export Wizard.Hit next. Select the option Choose the data Source,Under the database select the database which you want to take a copy of.Hit next
4.Your destination will be the new database which you created.Select it and Hit next
5.Select the option Copy tables and source from the source database.Hit next
6.Hit the option Select all
7.Hit next and next until the tables start copying
8.All the tables and views will be stored on to the new database.
Hopy it Helps
2.Right click the database which you created and select the ALL Tasks and then select IMPORT DATA
3.Now you should see DTS Import/Export Wizard.Hit next. Select the option Choose the data Source,Under the database select the database which you want to take a copy of.Hit next
4.Your destination will be the new database which you created.Select it and Hit next
5.Select the option Copy tables and source from the source database.Hit next
6.Hit the option Select all
7.Hit next and next until the tables start copying
8.All the tables and views will be stored on to the new database.
Hopy it Helps
•
•
•
•
Originally Posted by Shulc
in short words, yes
Save White Tiger
|
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
ad advertising ajax architecture asp avatar backup breach business centro crash daniweb data protection database dell design developer development doubleclick enterprise google government hacker ibm internet linux longhorn mail medicine microsoft mmorpg msdn news normalization novell office open qmail red hat rhel security server smtp software sql survey suse vista windows windows server
- Reading logs in MS SQL Server 2000 (MS SQL)
- Developing SQL Server 2000 (MS SQL)
- How to Backup database - SQL Server 2000 (MS SQL)
- sql server 2000 on win-xp pc (MS SQL)
- SQL SERVER 2000 Login failure in ASP.NET (ASP.NET)
- Ms Sql Server 2000 (MS SQL)
Other Threads in the MS SQL Forum
- Previous Thread: Ms Sql Server 2000
- Next Thread: SQL server connection
