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 |
|
kioteh
Starting Member
16 Posts |
 Posted - 2009-06-24 : 17:04:48
|
| I'm currently trying to replicate from SQL Sever to Oracle and its having an issue because one of the tables I'm replicating has column that is a reserved word in Oracle. Because its a reserved word, when SQL tries to execute an update command it errors because it's expecting "" around the column name. Any thoughts? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kioteh
Starting Member
16 Posts |
Posted - 2009-06-25 : 15:14:23
|
| I'm not sure what you mean. I'm using SQL Server replication. The replication itself is failing. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kioteh
Starting Member
16 Posts |
Posted - 2009-06-26 : 15:02:43
|
| It's a production machine with a mature application, that's not an option.Although if I could find the DBA that named the column "date", I'd have firm words for him/her. ;) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
topsportkid
Starting Member
2 Posts |
Posted - 2009-07-22 : 13:48:29
|
| hi,What is the tool you use for replication to OracleThanksTopsportkid |
|
|
|
topsportkid
Starting Member
2 Posts |
Posted - 2009-07-22 : 14:04:03
|
| Hi,In Oracle the column names is in upercase try "DATE" or [DATE].Topsportkid |
|
|
|
|
|
|
Replication to Oracle Issue