Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Tablediff and decimal separator

 
   Database Help (Home) -> Replication RSS
Next:  Is Open Office dying?  
Author Message
Diamond

External


Since: Dec 29, 2008
Posts: 1



(Msg. 1) Posted: Mon Dec 29, 2008 5:25 am
Post subject: Tablediff and decimal separator
Archived from groups: microsoft>public>sqlserver>replication (more info?)

Hi,

I'm using tablediff to compare tables from two different databases and
generate an update script. I'm facing a problem with tables that contain a
decimal column.
The decimal separator is a ',' on my databases, since I'm in france, so the
script that is generated by tablediff contains ',' for field separators in
insert commands and ',' for decimal separators. In consequence, the script
is useless.
Is there a way to change this behavior and have tablediff generate '.' as
decimal separator in the scripts ?

Thanks
David

 >> Stay informed about: Tablediff and decimal separator 
Back to top
Login to vote
Paul Ibison

External


Since: Oct 03, 2008
Posts: 145



(Msg. 2) Posted: Mon Dec 29, 2008 12:41 pm
Post subject: RE: Tablediff and decimal separator [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi David,
I can't test this right now, but my guess is that the setting is being
inherited from the default language of the login you are using. Please can
you create a new SQL login with a different language to test this.
HTH,
Paul Ibison

 >> Stay informed about: Tablediff and decimal separator 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Tablediff source code - Will Microsoft release the source code for SQL Server 2005 tool tablediff? At present, this tool does not handle if one wants to only find additions to the source database. In our case we want to find new additions to the source database so that we ca...

tablediff SQL 2005 - Oracle - possibile? - Hi All, Is it possibile to compare the content between two replicated databases (tables) from Oracle to SQL 2005? I found someone mentioning going through linked server. How can I make it from the command line tablediff.exe? Thank you, Vladimir

how to? - I have transactional replication running in sql2000. I need to find out whether there are pending transactions to be replicated and I need to do this query. Is there any way?

Trans Replication with all types of objects published - Correct me if im wrong but do i need to create many publications for SQL should i have stored procs,views,indexed views,etc in addition to the tables ? It seems that when i have just one publication with all these objects published in it and when the..

SnapShot Agent Schedule in Merge Replication.. - Hi All: I have setup a Merge Replication over VPN. It has setup the Snapshot Agent Schedule to run Once every 1 week. & I have set the Merge Agent to run continuously. Can I change the snapshot agent schedule to run on Demand? Can this is configure...
   Database Help (Home) -> Replication All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]