On Oct 11, 8:18 am, Matt <mdw...@gmail.com> wrote:
> Hi All,
>
> I have a few questions on transferring data between SQL Servers
> (please keep in mind I am using Express 2005).
>
> Situation:
> -----------------------------------------------------
> I have a SQL Server database on my server. I want this same exact
> database on my local machine so that I can take it home and work on it
> without being at the mercy of our VPN.
>
> Here is what I have tried so far:
> 1.) Creating a backup - I backed my database up on the server, but
> have no way to get this backup file on to my local machine (the
> network admin, the only person with the password to the server is out
> all week). Therefore it does me no good.
>
> 2.) Script Database - I have successfully created the structure of the
> database using this method, but have no data to work with.
>
> *****************************************
>
> Now, I know that I can use MS Access with a couple of ODBC connections
> and move the data around, but there has to be an easier and better
> way, right? I have read about DTS, but am under the impression that
> this is not an available feature in the express edition. Is there
> some way to script the tables on my source database as INSERT INTO
> statements that I could run on my local copy? Any other suggestions?
>
> I am relatively new to SQL Server, so if I am leaving anything out or
> you need more details let me know!!
>
> Thanks in advance,
> ~Matt