dts question

[ktucci]

what is the best way to copy a db from one sql server to another sql server....all i need are the the table and data...then from that point i will need to copy and replce all of the data on a daily basis...i know that dts is probably the answer....can someone give me a little more details as to what i need to do within dts to accomplish this...

thanks in advance

keith

 

[ColinM]

You could probably use any of these

a) DTS
b) Backup & Restore
c) Replication
d) Script tables & BCP data

I would think the backup & restore option would be the easiest to implement unless you have specific reason not to do that.
Using DTS goto the task menu and have a look at transfer objects.

 

[ktucci]

can i use backup and restore from one sql server to another...if so, any ideas on how to do it...

 

[tlbroadbent]

I just responded to a similar question in thread183-85702.

In short, you can backup on the source server and restore on the destination server. When restoring, in Enterprise Manager, type in the database name, select restore from device and browse to the location of the backup file. Terry

;-) I never worry about the future. It comes soon enough. -Albert Einstein

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm

 

[ktucci]

thanks...that is what i was looking for