Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Karander
Starting Member
34 Posts |
 Posted - 2006-05-03 : 08:27:45
|
| Hi, I reall need some advice ... cause I stuck ...I have two databases: MYSQL MSSQLI have to synchronize datas between these databases.The structure of tables, relations is the same.When I detect which record has been inserted/updated/deletedin myssql database i have to make changes in mysql.And: - inserting new record to MYSQL cause that: - new ID of inserted record (in mysql) must be the same in mssql (so i need to update identity column in mssql database, however mysql's new ID may be repeated with another record in mssql table and everything may start complicating ... - updating record must assume that ID of records in 2 database tables have same content ...hehm i really don;t know how to get down to do it ....The first problem i met is updating identity column in mssql server ... Is it possible, how to do it ??And generally if somebody could advise me with synchronising databases I would really appreciate it...Thx for all |
|
|
|
|
|
Synchronization ....