Hi All,
SQL SERVER 7
I am trying to synchronize 4 db from staging to development server.
all the 4 db r present on development but not in synchronization
with the staging. im not able to restore the db directly as the
sort_id is different b/w two servers. i am creating a DDL script of
.sql file and creating a temporary db and running the .sql file and
import data and then restoring it to the original db. i was able
to do it for 3 db. but fourth db gives an error when i run the
.sql for one stored procedure
the error is
"insert error:column name or number of supplied
values does not match table defnition."
I tried checking out
the datatypes of all the columns stated, they r same.
pls let me know if anyone has any idea regarding this. as this is urgent
TIA
Regards
AdilHaven't you tried with BCP?|||That's a DML error...
Post the offending script and we might be able to help..
Also if you double click on the error it'll bring you to the offending clause...
No comments:
Post a Comment