May 5, 2012 at 11:16 am
Hello Everyone,
I have some general question. In my environment we have a 3rd party company database. This database is couple of months old. Now the same 3rd party company giving us another copy of there database (backup file), where they have made changes all these days. I would like to restore that backup file to the existing database on my environment. So, how can I upgrade the new data in my existing database, so that I can get all the new updated information. Do we have any process for this to work on. Please, let me know. Thank you.
May 5, 2012 at 2:31 pm
First I would call up the support of your TPV and ask them exactly what their definition of an upgrade is. It's surely not a higher version database backup.
The reason I say that is because there is no built-in SQL Server tool to accomplish a schema upgrade while preserving data. You're going to have to use another tool to get your database up to the current version while preserving data. I recommend SQL Compare by Red Gate. Great tool.
You should really make the TPV cough up some if not all of it to purchase, if you're paying an ongoing maintenance or upgrade support from them.
May 6, 2012 at 6:30 am
Agree with Tomas but I wouldn’t just ask for what they have changed, I would also for backward compatibility of their own product. It really doesn’t make sense, every time they upgrade something you need to rewrite a data import tasks. Include it in support agreement if it’s not already there.
Another suggestion would be, don’t go for a product upgrade if the pain of data import is relatively high over the advantages of upgrade.
May 6, 2012 at 11:58 am
Thanks All. It is not the database upgrade. It is only the data upgrade. As the company has modified it, so I need to make those changes into my existing database. So, as you said we might need is a third party tool to compare and load, which is a good option. Also, I have some script which defines the comparison of database.So, I think I will use that and later on work with Import and Export wizard. Is that ok, which solves the upgrading existing database issue.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply