i was wondering how can database replication on a sql server be accomplished?
Shulc 0 Newbie Poster
Letscode 1 Junior Poster
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?
Shulc 0 Newbie Poster
in short words, yes
Letscode 1 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
in short words, yes
Shulc 0 Newbie Poster
thnx, that helped a lot!
AnilPatil 0 Newbie Poster
Do u known how to use replication of data base in sql server 2008
dhirajraj1 0 Newbie Poster
To copy complete database including stored procedure, functions etc..you must have to choose the option "copy object and Data between SQL Server database" otherwise only tables with data would get copied
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.