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