Best Way to Sync SQL Srv Databases
-
Hi all, I would need to sync data between two databases with diferent structure. It happens that in one Database (A) i have just 2 or 3 tables (with lot of fields), and on the other database i should have the same data splitted on many other tables. To Sync this i will to create a lot of triggers that are fired on both database tables but some fields data type were also changed like: Where i have field data type NVarchar() on database A the same correspondent field on Database B is Int(). On database A the field can assume the values Yes/No/In Progress but on databse B the same field assumes the values 1/2/3. Are a lot of triggers to do! Wich should be the best way to do this? Wich is the best way to convert the data between tables? Is there some tool to help me doing this like Sybase ETL? Best Regards,
-
Hi all, I would need to sync data between two databases with diferent structure. It happens that in one Database (A) i have just 2 or 3 tables (with lot of fields), and on the other database i should have the same data splitted on many other tables. To Sync this i will to create a lot of triggers that are fired on both database tables but some fields data type were also changed like: Where i have field data type NVarchar() on database A the same correspondent field on Database B is Int(). On database A the field can assume the values Yes/No/In Progress but on databse B the same field assumes the values 1/2/3. Are a lot of triggers to do! Wich should be the best way to do this? Wich is the best way to convert the data between tables? Is there some tool to help me doing this like Sybase ETL? Best Regards,
You could possibly use SSIS to achieve most of what you're after. How current do both databases need to be?
-
Hi all, I would need to sync data between two databases with diferent structure. It happens that in one Database (A) i have just 2 or 3 tables (with lot of fields), and on the other database i should have the same data splitted on many other tables. To Sync this i will to create a lot of triggers that are fired on both database tables but some fields data type were also changed like: Where i have field data type NVarchar() on database A the same correspondent field on Database B is Int(). On database A the field can assume the values Yes/No/In Progress but on databse B the same field assumes the values 1/2/3. Are a lot of triggers to do! Wich should be the best way to do this? Wich is the best way to convert the data between tables? Is there some tool to help me doing this like Sybase ETL? Best Regards,
You can try D-Softs Database Compare Tool