July 9, 2005 at 1:08 pm
I have SQL Management Studio on my desktop. I use it to manage my SQL Server 2000 database instances (one on DEV and the other on PRD). I connect to both my instances and I can see them both in my Object Explorer. So far so good.
Now in my DEV instance, I've created a table tbl1. I want to copy this table (INCLUDING DATA) over to my PRD instance. I can copy the table over (WITHOUT THE DATA) by righ-clicking on the table and then selecting "Scrtip Table As->CREATE To->New Query Editor Window" and then running the script on PRD. This successfully creates the table in PRD but does not copy the data. What do I need to to that?
July 9, 2005 at 6:25 pm
You can use the import data wizard on the target server's database. Or you can use dts (copy object task). It's all wizards and easy to understand in both cases.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply