SQL Server Data migration


#1

Any tools (SQL SERVER SSDT etc.) that can be used to migrate the data from SQL Server/Oracle databases onto Couchbase?


#2

Hi @rkbnair,

Some tools I’m aware of that might help you:


#3

Ok, great, thanks Matthew !


#4

Hi 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
project, but it doesn’t have ‘View’ pages rather it is using javascript
mostly.

Could you direct me to the right link please?

Justin Tuggle asked me to give you his reference.

Thanks.


#5

Hi Matthew, how to restore ‘hello-couchbase’ mentioned in your sample
starter?


#6

@rkbnair,

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)


#7

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

System.AggregateException occurred
HResult=0x80131500
Message=Could not bootstrap - check inner exceptions for details.
Source=Couchbase.NetClient
StackTrace:
at Couchbase.Core.ClusterController.CreateBucket(String bucketName,
String password)
at Couchbase.Core.ClusterController.CreateBucket(String bucketName)
at Couchbase.Cluster.OpenBucket(String bucketname)
at Couchbase.ClusterHelper.<>c.b__10_0(String name)
at System.Collections.Concurrent.ConcurrentDictionary2.GetOrAdd(TKey key, Func2 valueFactory)
at Couchbase.ClusterHelper.GetBucket(String bucketName)
at Starter.Models.ProfileRepository…ctor() in
C:\00TFS\aspnetmvcmaster\asp-net-mvc-master\starter_complete\Starter\Models\ProfileRepository.cs:line
16
at Starter.Controllers.HomeController…ctor() in
C:\00TFS\aspnetmvcmaster\asp-net-mvc-master\starter_
complete\Starter\Controllers\HomeController.cs:line 14

Inner Exception 1:
AggregateException: One or more errors occurred.

Inner Exception 2:
AuthenticationException: bkt_MyBucket


#8

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 ProfileRepository constructor.


#9

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???


#10

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


#11

@rkbnair,

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).