June 16, 2011 at 2:43 pm
Hello all,
To start with I would like to say that I’m not 100% sure with forum to post this question, I hope I’m in a good forum and that I don’t offend anyone if I’m not.
We’ve run into an issue with exporting data and were hoping someone would be able to help. We have 2 servers and all we need to do is move that data from server 1 to server 2 and neither server can be stopped. The tables are identical in both servers. We are trying to use the ‘export data’ function and everything seems to work except the delete. In the window were you select what tables to export we select all the tables and then click the edit mapping button. This brings up a window that has a selectable option that says ‘delete rows in existing destination tables’. It is the only option on that page that we select. When the export runs all the data does get transferred, but instead of the rows being deleted they get appended. Why doesn’t it delete the rows in the existing destination tables?
And for a second question, in the above situation is there a better way to move the data than the ‘export data’ function?
Thanks great for you time
Bernie
June 17, 2011 at 2:29 pm
I think more info might be needed to best answer this.
1. Are you running this process on a recurring basis?
2. Are all rows in the destination table deleted each time this process is run?
If this is to be done on a recurring basis an SSIS process should probably be developed to move the data.
-Dan
June 19, 2011 at 5:03 am
Hi,
Think you are just exporting data right ?
as far as the import export concept it always going to append your data.
If you want exact same data the on secondary server just truncate the tables first and reseed them and then export.
I hope this may help you.
June 20, 2011 at 12:06 pm
Thank you for your replies. After many hours of work/testing we've discovered that is seems to be a permissions issue. For some reason the admin account we are using doesn't have the right or enough permissions. We are still in the process of narrowing that down. In the end we've discovered that a SSIS package will give us more features that we can use so we are going that route.
Again, thansk a lot
Edit
In the end, it had nothing to do with any permissions. It all had to do with the lack of experience with SSIS packages.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply