[AccessD] Arvixe web hosting

I do a backup and restore it on the Arvixe server. If you look at the
hosting account you will see a data folder. Put your backup there. I use the
Arvixe Database control panel to do the restore. It will look in the data
folder. I tried briefly to do a restore using SQL Server Management Studio,
but had file permission issues so went with the inhouse tool. You can create
users in the online database control panel. I have not tried setting up
security through SQL Server Management Studio on the Arvixe site.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Wednesday, October 24, 2012 7:31 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Arvixe web hosting

I am in, I have created an empty database and I have SSMS connecting to it
using SQL Server Security and my username / password.

It is somewhat disconcerting to see 47 SQL Server databases running on a
single SQL Server Express server.  Hmmm...

What I am trying to figure out now is how I move an existing database from
my system to theirs.  I assume a backup / ftp / restore but it seems like
there are going to be issues to overcome.  For example I use a windows user
and windows security for creating and managing the databases on my system.
Thus the "owner" is jwcolby on my server.  There is no jwcolby user on their
system (at windows level).

If I don't do a backup / restore, then even if I manage to script every
object and build that out on the host server how does one get the data over?

John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

On 10/24/2012 2:00 PM, Jim Dettman wrote:
> John,
>
> <<I assume that If I go with this company the same methodology is 
> going to work except that the IP will now be ColbyConsulting.com,1433? 
> >>
>
>    That would be the case as a DNS entry just translates to an IP anyway.
> The advantage to using DNS is that you can swap out servers, which 
> have different IP's, and nothing changes for the end user.  This is 
> true with anything (HTML, FTP, TELNET, AS2, etc)
>
> Jim.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com