HyperGeek - 8:34 pm on Feb 10, 2005 (gmt 0)

Yeah, I'm just getting into SQL and was told by my host that I needed MS Exchange to download, manage, backup, and upload my SQL database from a local source. My tables ocassionally need appending as I update the online apps I'm developing, and I wanted some way to do this efficiently - as it takes a year and a freakin' day to do it to an online SQL DB.

I have everything else that's required to run Exchange, besides having a domain setup. I'm starting to realize that I cannot setup domains on XP Pro.

After a bit of research, I also think I may have found a workaround. I have Enterprise Manager setup, and SOMEHOW - by DLing a bunch of updates and such ("SQL desktop" or something like that), I am running SQL on my computer - which is really weird to me since I only installed the Enterprise Manager and not SQL Server (since I assumed the SQL Server demo would expire eventually.)

Through a few hours of knocking around with Data Sources, I have SQLmgr loading up at boot, and after DLing those updates from the MS site, I now have a little tray icon that sources back to my IIS root.

So now I can use Enterprise Manager to connect to the online SQL DB, and I can backup the file to the IIS root folder and then load and edit it on my mysterious local server that happens to exist now. lol

I'm such a n00b at this since I've used Access for the last four years - but at least I'm a n00b with the functionality he's looking for. :)

This is extremely foriegn territory for me, and I attribute it much more to luck than skill... so any explaination as to why this is working now, or tips, would be appreciated.

;D