November 23, 2010 at 9:18 am
Hi Phil, thanks for getting back.
There is no datbase on the other side, I just wanted to transfer the database along with everything into the 2008 instance (hence setting the model database to 90), do you think it would work better if I created an empty database on the 2008 instance and then set it 90?
Kind Regards,
D.
November 23, 2010 at 10:00 am
That won't make your problem go away.
This sounds like a job for backup/restore to me 🙂
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
November 24, 2010 at 1:44 am
Thing is I hve tried that and it misses too much stuff. Its so annoying that the Transfer objects task is what I need, but does not work properly.
Regards,
D.
November 24, 2010 at 1:51 am
I'm sorry, I don't know what else to suggest.
This link suggests that what you are trying to do should work just fine.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 31, 2014 at 1:54 am
I am aware this is an old post but thought I'd share my findings.
Each database does appear to need the same compatibility level. If you go to both databases using SSMS then goto properties of each database and then select options if you check that both compatibility levels are the same Then the "Transfer Objects Task" module in SSIS will work.
This has worked for me and has not appeared to have any knock on effects to anything else.
Hope this helps someone out there.
March 2, 2015 at 12:53 am
Set the destination to compatibility to 100 and it will work
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply