Forums :: Swyx Forum

Forums Server Setup Moving Swyx Database to another server (only the DB!)

7/8/2008 10:14 AM

	spyker
78 posts

Moving Swyx Database to another server (only the DB!) (Switzerland)

Hello again!

One customer has several servers.. now he asked me, if I could move the Swyx DB from the Swyx server to his database server..

I spent some time on this.. and my idea was, to run the config wizard again.. and then on the " connect to sql server"-screen,
I would just change the location from (lokal)\SQLEXPRESS to databaseserver\Swyx...

If I don't have any problems with not enough rights.. should this work?

Thanks..

spyker

7/8/2008 10:32 AM

	Martin
232 posts

Re: Moving Swyx Database to another server (only the DB!) (Germany)

The account you're using to access the SQLServer (first SQL login you specify in ConfigWizard) must have db_owner rights on the database (It's not necessary to have a SQLServer administrative role). The second SQL login you enter in ConfigWizard is the account SwyxWare later uses to access the database. Make sure that the login exists on the SQLServer. ConfigWizard will configure the SQL login as user in the database and sets proper access permissions.

Summary:

First SQL login in ConfigWizard: Connects to the SQLServer for administration. Needs to have db_owner rights on the existing database.

Second SQL login in ConfigWizard: Used later by SwyxWare to access the database. Login must exist before ConfigWizard runs. Database user roles are configured by ConfigWizard.

Martin Hüser
Team Lead, Server Development, Swyx

7/8/2008 10:32 AM

	Morten Rokosz
793 posts
gui.this-is-voip.net

Re: Moving Swyx Database to another server (only the DB!) (Norway)

Modified By Morten Rokosz on 7/8/2008 9:35:43 AM)

First of all it might not be that easy to backup a SQLEXPRESS database and restore it on a SQL 2005 Server. I have tried it a couple of times and it fails for not finding the correct paths. Searching the Net it seems that this is a limitation of the SQLEXPRESS.

Do you run into problems when you are retoring the database onto the SQL server, or do you manage to do that?

UPDATE: I deleted my original text here, as Martin gave a better explanation. We seemed to write it at the same time, look at the post time

Morten Rokosz
(Swyx T.A.G Member)

Captain of the Golgafrinchan Ark Fleet Ship B

The best way to predict the future is to invent it.

7/8/2008 10:41 AM

	Martin
232 posts

Re: Moving Swyx Database to another server (only the DB!) (Germany)

Morten Rokosz wrote

First of all it might not be that easy to backup a SQLEXPRESS database and restore it on a SQL 2005 Server. I have tried it a couple of times and it fails for not finding the correct paths. Searching the Net it seems that this is a limitation of the SQLEXPRESS.
I 'm sure it's possible. All MSSQLServer backups contain the complete paths of the database file and transaction log file. If you just try to restore a DB from one server to another these paths might be wrong on the new server.

When you're using SwyxWare's restore.wsf script you can specify the paths to use with parameters /m and /l. When using ConfigWizard that's done automatically. In spyker's scenario using ConfigWizard is not possible, however, because the SQLServer is on another system. But that's no problem, because SQLServer Management Studio allows changing the paths during restore, too.

Martin Hüser
Team Lead, Server Development, Swyx

7/8/2008 12:15 PM

	Morten Rokosz
793 posts
gui.this-is-voip.net

Re: Moving Swyx Database to another server (only the DB!) (Norway)

Martin Hüser wrote

I 'm sure it's possible. All MSSQLServer backups contain the complete paths of the database file and transaction log file. If you just try to restore a DB from one server to another these paths might be wrong on the new server.

You are right. I tried this now with a IpPbx database from a SwyxServer running Express locally. I did manage to restore it on my SQL 2005 Server. There must have been some other dependencies in the databases I had problems with.

Morten Rokosz
(Swyx T.A.G Member)

Captain of the Golgafrinchan Ark Fleet Ship B

The best way to predict the future is to invent it.

Page 1 of 1

Forums

Server

Setup

Moving Swyx Database to another server (only the DB!)

Forum Policy

The discussion forums at Swyx Forum are dedicated to the discussion of Swyx, SwyxWare and related topics.

For the benefit of the community and to protect the integrity of swyx-form, please observe the following posting guidelines:

No Advertising. This includes promotion of commercial products and non-commercial products which are not directly related to SwyxWare, it's OEM versions or a forum topic.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Furthermore, make sure your posts comply to our Terms of Use.
Newest development in German law defines online forums as journalistic content, making the forum owner and all posters to journalists. With this statement the forum owner declares that neither he nor his users are journalists with all legal consequences.
The forums are currently unmoderated, meaning all postings will appear immediately after submission. If this turns out not working due to massive abuse all forums will switch to moderated mode, meaning a posting must be approved after submission my a moderator before appearing.
You can use any language you like (except for the project forums) but keep in mind that by using english you will reach the largest audience.
Within the project forums english language is mandatory.