[AccessD] Arvixe web hosting

Check the script generator.
You can also script the data.


At 01:50 PM 10/26/2012, you wrote:
>Date: Wed, 24 Oct 2012 22:30:30 -0400
>From: jwcolby <jwcolby at colbyconsulting.com>
>To: Access Developers discussion and problem solving
>         <accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Arvixe web hosting
>Message-ID: <5088A446.6080209 at colbyconsulting.com>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>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?

Robert L. Stewart

Any fool can write code that a computer can understand. Good 
programmers write code that humans can understand. --Martin Fowler

www.WeBeDb.com
www.DBGUIDesign.com
www.RLStewartPhotography.com