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 |
|
manu
Starting Member
41 Posts |
 Posted - 2006-01-09 : 08:45:23
|
| Hi All,i am trying to make a DTS Package for backup of my organisation's Data. i have selected 'Appending the rows' in my package. but when i run it the data is replicated and tables in which identity column is inserted, i got the error.Pls help me in solving the problem.Munish Gupta |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-01-09 : 09:00:29
|
| What is the purpose of the backup? Sounds like you might not be using an appropriate method - difficult to say without more info.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
manu
Starting Member
41 Posts |
Posted - 2006-01-09 : 10:07:24
|
| yes sir,i want to make a backup of datbase from one matchine to another matchine using import and export wizard. i have made one DTS PAckage for this.i want to append the rows.Munish Gupta |
|
|
|
manu
Starting Member
41 Posts |
Posted - 2006-01-09 : 10:47:55
|
| i don't want to get similar data replicated but want to append the rows in backup table. |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-01-09 : 10:55:29
|
| manu,Backing up database is not the same as Data Transfering (which is the purpose of DTS).If u want to backup only data, then ur way would be OK, but its not backup database.In ur database u don't have objects other than data (eg views, stored procedures, triggers etc ?Import & export wizard can be used to move data among databases.eg. From database A, u can export several tables and some records of some other tables to a Database B.So tell us ur requirement!! |
|
|
|
manu
Starting Member
41 Posts |
Posted - 2006-01-10 : 01:06:29
|
| Yes, i want to transfer my data only not objects.on tranferring my data, same data is replicated again but i want to append my rows.Munish Gupta |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-01-10 : 08:12:34
|
| How do u know, whether the data are new or changed or deleted in the source database?I think u may need replication.If u r worried only about inserting data, u can use DTS with a Query (instead of selecting a table name), which checks for the same record using Not Exists and the fully qualified name of table (SQLSvr.User.TableName) |
|
|
|
|
|
|
|
|
Problem in backup of database