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.
| Author |
Topic |
|
carau2007
Starting Member
31 Posts |
 Posted - 2007-10-01 : 09:51:42
|
| Hi,I am using SQL 2000. I have two DB's one is live and the other is developement. I need to copy the live DB over the developement DB but I can't overide certain tables.How do I go about? Do I need to this using transact? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-10-01 : 10:26:17
|
| backup the prod db and restore it on your dev server under a different name.then just transfer desired tables over with simple T-SQL_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-01 : 22:00:17
|
| Or use dts to copy tables directly if table size is not that big. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-10-03 : 06:24:20
|
| You could also do a "Generate Script" for the CREATE DATABASE side of things. Then do the transfer data to whatever objects you requireJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com/SQL |
|
|
|
|
|
|
Newbie: Copy database but not tables