Any tools (SQL SERVER SSDT etc.) that can be used to migrate the data from SQL Server/Oracle databases onto Couchbase?
Some tools I’m aware of that might help you:
- Talend - there is a Couchbase connector for it https://developer.couchbase.com/documentation/server/current/connectors/talend/talend.html
- CData, which also has an available Couchbase connector - http://www.cdata.com/drivers/couchbase/
Ok, great, thanks Matthew !
I am looking for a sample mvc5/6 visual studio .net c# project that uses
Coudhbase as the backend for creating my POC. I tried try-cb-dotnet
Could you direct me to the right link please?
Justin Tuggle asked me to give you his reference.
Hi Matthew, how to restore ‘hello-couchbase’ mentioned in your sample
There’s nothing special about the “hello-couchbase” bucket. You can just create a new empty bucket with that name or whatever name you’d like. You’ll also need to CREATE PRIMARY INDEX ON `hello-couchbase` after you’ve created the bucket.
Here’s the documentation for creating the bucket: https://developer.couchbase.com/documentation/server/current/clustersetup/create-bucket.html
Here’s the documentation for using the Query Workbench (where you would run the CREATE PRIMARY INDEX statement): https://developer.couchbase.com/documentation/server/current/tools/query-workbench.html
(For anyone else watching this thread, the starter kits that @rkbnair is referring to are here: https://developer.couchbase.com/documentation/server/4.6/getting-started/starter-kits.html)
Something is still not right;I used another database that had primary index
set already. How come no place to specify userid/password?
Getting inner exception
Message=Could not bootstrap - check inner exceptions for details.
at Couchbase.Core.ClusterController.CreateBucket(String bucketName,
at Couchbase.Core.ClusterController.CreateBucket(String bucketName)
at Couchbase.Cluster.OpenBucket(String bucketname)
at Couchbase.ClusterHelper.<>c.b__10_0(String name)
2.GetOrAdd(TKey key, Func2 valueFactory)
at Couchbase.ClusterHelper.GetBucket(String bucketName)
at Starter.Models.ProfileRepository…ctor() in
at Starter.Controllers.HomeController…ctor() in
Inner Exception 1:
AggregateException: One or more errors occurred.
Inner Exception 2:
If you put a password on the bucket, then you’ll need to change the
ClusterHelper.GetBucket("hello-couchbase") in the starter kit to
ClusterHelper.GetBucket("hello-couchbase", "password"). This would be in the
I am confused; this is not the database password, but the Couchbase Console admin password. Global asax file shows the local server path, new Uri(“http://localhost:8091”), but no userid/password???
the travel sample grabs the userid/password from web.config…
var bucketName = ConfigurationManager.AppSettings.Get("CouchbaseTravelBucket"); var username = ConfigurationManager.AppSettings.Get("CouchbaseUser"); var password = ConfigurationManager.AppSettings.Get("CouchbasePassword");
Do not see anything like that in starter project
I probably didn’t use web.config for that example, and I may not have used a password at all. With 4.x it is optional to put a password on a bucket. I don’t know why the travel sample is getting the admin username and password: perhaps there are some operations or REST calls it is making that requires them. But for basic read/write, you don’t need the admin credentials, just the bucket name and bucket password (if there is one).