[thelist] Differing SQL Server Versions and Backups

[Jay Turley]

Thanks, Ken and Anthony!

So, if I'm hearing you fellows right, what you are saying is:

1) Install SQL Server Express 2005 on my dev machine
2) Use SQL Studio Manager Express to load the SQL Server backup from my
webhost into SSE 2005

It's step 3 that gets me. My ideal would be to be able to get that data into
SQL Server 2000 on my dev machine. But from what you have said it seems like
I should

3) Connect my dev/staging apps to the new SQL Server Express 2005 I
installed in (1) above, or

3) Somehow get my data from SQL Server 2005 to SQL Server 2000 (write a
quick data xfer app?)

Thanks for any further thoughts!

-Jay

On Wed, Aug 19, 2009 at 7:17 PM, Anthony Baratta <anthony at baratta.com>wrote:

> I would upgrade if you get the chance, but in the meantime - why not run
>  MS SQL Express 2005? With MS SQL Studio Manager you should be able to
> take the backups and import them into Express 2005. Or whatever
> myLittleBackup does with the data.
>
> That should band-aid it for a while.
>
>
> --
> Anthony Baratta
>
> The world I believe is far too serious, and being far too serious, it
> has need of a wise and merry philosophy.
> — Lin Yutang
>
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>