Hi all
I'm pretty new to SQL Server so apologies if i'm missing something obvious.
Basically, I'm using Management Studio to do a full export/import from one database to another (with identical structures).
I have already figured out that I need to turn off the 'Optimize for many tables' option in order for the 'enable identity inserts' to work and this is fine. But, i'm still getting a few tables where NULL values are converted to the number 0 in the import and I don't know why or how to prevent it?
Can anyone help me with this?
Many thanks in advance.
Farren Minns