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...
Showing posts with label synchronize. Show all posts
Showing posts with label synchronize. Show all posts
Subscribe to:
Posts (Atom)