Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Move the data between different server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2007-02-15 : 09:21:38
Ruban writes "Hi

How can we transfer the data between two server. We need to transfer the data between PRODUCTION server to STAGE server with online process.

Please can you provide some possible ways with example. Now we are struggling here (Only TSQL)

Regards
Ruban"

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-02-15 : 10:07:44
bacup the db on prod and restore it on staging. - this is simpler
or use a DTS.



Go with the flow & have fun! Else fight the flow
blog thingie: http://weblogs.sqlteam.com/mladenp
Go to Top of Page
   

- Advertisement -