Migrate Back End to SQL Server 2012

[StevenTCramer@gmail.com]

So installed and had the CE system working fine. And wanted to migrate to SQL Server 2012.

I tried to use the migration tool which failed.

The database {0} can't be created. Check the server log (plastic.server.log). Error: {1} at Codice.CM.Data.BaseDataManager.ExecuteCreateDatabaseScript(String databaseName, String contentResourceName)

at Codice.CM.Data.BaseDataManager.CreateRepositoriesData()

at admintool.RepositoriesDatabaseCopier.CreateDestinationDb()

at admintool.DatabaseCopier.Start()

at admintool.DatabaseMigrator.MigrateDatabases()

at admintool.DatabaseMigrator.Start()

and I then went to update my db.conf file route and I do now have it working. Of course that isn't migrating but since I had nothing in it didn't matter.

video of the process to reproduce the above error is located https://dl.dropbox.com/u/7761816/2012-10-09_1712.swf

[manu]

Hi Steven,

can you please tell us if starting the Plastic SCM server working with the SQL Server the default databases are created?

I would like to get connected with you in order the get more info and resolve the issue.

[StevenTCramer@gmail.com]

Once I went to the db.conf option it created all the default dbs in SQL Server 2012.

[manu]

Unfortunately I can't reproduce the issue, I'm using SQLServer 2008.

Can you check if defining the path for the databases makes the difference? Maybe it's a permissions issue.

[alpha88]

I encountered the same problem while trying to migrate on Server 2012 with SQL 2012.

It appears to be a file permission issue, as when I specified the path as the sql server default path, it worked without error.

[manu]

Thanks for the info!

Let me test that scenario.

[Tatiana]

It appears to be a file permission issue, as when I specified the path as the sql server default path, it worked without error.

Indeed, this solves the problem. Thank you very, very much.

The default path would be something like:

C:\Program Files\Microsoft SQL Server\MSSQL11.YOURINSTANCE\MSSQL\DATA

[manu]

Happy to hear that it was a permissions issue, in this cases the "plastic.server.log" file is very useful since the exception gives us a lot of information.

[jdharley]

I am having a similar problem with starting a new instance with SQL Server 2012, but my instance is configured to use Windows authentication (rather than separate db-supplied login credentials). I see that there is an example using "trusted_connections=yes" and I've changed my db.conf file to use that.

What are the steps I should take to start a new instance?

[manu]

Hi jdharley,

you can use that authentication mode with a selector like the following:

<DbConfig>
 <ProviderName>sqlserver</ProviderName>
 <ConnectionString>SERVER=localhost\SQLEXPRESS;trusted_connection=yes;DATABASE={0};</ConnectionString>
</DbConfig>

check if the databases are created, you should see something like:

C:\Users\Manuel>cm lrep
1 default localhost:8087

if you want to specify a custom database path you will need to use a "db.conf" file like the following, make sure the SqlServer process has write permissions on the desired databases path.

<DbConfig>
 <ProviderName>sqlserver</ProviderName>
 <ConnectionString>SERVER=localhost\SQLEXPRESS;trusted_connection=yes;DATABASE={0};</ConnectionString>
 <DatabasePath>d:\repositories</DatabasePath>
</DbConfig>

If you don't see any database check the server log (c:\Program Files\PlasticSCM4\server\plastic.server.log), search for errors in the database connection. You can post the log file to us in order to review it.