Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Using it with MSSQL Server #63

Open
yasin-amadmia-mck opened this issue May 22, 2018 · 1 comment
Open

Using it with MSSQL Server #63

yasin-amadmia-mck opened this issue May 22, 2018 · 1 comment

Comments

@yasin-amadmia-mck
Copy link

yasin-amadmia-mck commented May 22, 2018

Hi,
Can it be used with MsSQL Server ? Possibly using https://github.com/rails-sqlserver/activerecord-sqlserver-adapter ? I actually installed the sqlserver-adapter and then when i do

require 'data-anonymization'
require 'activerecord-sqlserver-adapter'

database 'Test_DB' do
  strategy DataAnon::Strategy::Blacklist
  source_db :adapter => 'SQLServerAdapter', :host => 'x', :port => 999, :username => 'x', :password => 'x', :database => 'x'

  table 'Persons' do
    anonymize('FirstName').using FieldStrategy::RandomString.new
  end

end

It throws this error

/usr/lib/ruby/2.4.0/rubygems/specification.rb:2294:in `raise_if_conflicts': Unable to activate activerecord-sqlserver-adapter-5.1.6, because activerecord-5.0.7 conflicts with activerecord (~> 5.1.0) (Gem::ConflictError)
        from /usr/lib/ruby/2.4.0/rubygems/specification.rb:1414:in `activate'
        from /usr/lib/ruby/2.4.0/rubygems.rb:220:in `rescue in try_activate'
        from /usr/lib/ruby/2.4.0/rubygems.rb:213:in `try_activate'
        from /usr/lib/ruby/2.4.0/rubygems/core_ext/kernel_require.rb:126:in `rescue in require'
        from /usr/lib/ruby/2.4.0/rubygems/core_ext/kernel_require.rb:39:in `require'
        from /var/lib/gems/2.4.0/gems/activesupport-5.0.7/lib/active_support/dependencies.rb:293:in `block in require'
        from /var/lib/gems/2.4.0/gems/activesupport-5.0.7/lib/active_support/dependencies.rb:259:in `load_dependency'
        from /var/lib/gems/2.4.0/gems/activesupport-5.0.7/lib/active_support/dependencies.rb:293:in `require'
        from test.rb:2:in `<main>'
@sunitparekh
Copy link
Owner

It is difficult for me to get all setup done on Mac for SQL Server and try it. If this doesn't work for you. Give a try to Java/Kotlin port of same tool which works with JDBC driver.
https://github.com/dataanon/data-anon

to kickstart you can use Kotlin sample or Java Sample

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants