how can transfer the data?

[vasavivenu]

Hi,

I have two databases named S1 and L1, here i need to delete all the data in L1 and transfer the data(records Only) from S1 to L1. Don't modify the structure of the L1 database.


Thanks in advance
Vasavivenu

[Rabbit]

Truncate L1 and then run an insert into to get the data from S1 to L1. That's how you do it for tables. However, you said database. In which case I can only assume you mean two databases with multiple tables on the same server. Just run it on each table.

[vasavivenu]

Thank you,
I follow this process, i got error in some tables,the error is :

Server: Msg 8114, Level 16, State 5, Line 1
Error converting data type nvarchar to float.

But, I verified all the attributes are same data types. How can i over this problem?

Thanks
vasavivenu

[Rabbit]

I can't say anything about the error because I don't know what SQL you ran and your table definition.