September 2, 2003 at 8:17 am
I am working as a SQL-Server2K developer on a distributed team of a dozen web site developers working in DotNet. We want all users to have the current development (test) database for their use without requiring everyone to buy SQL-Server. How can I convert our SQL-Server database to MDAC for distribution to local developmers ?? The database does use a modest set of tabels, stored procedures, and little else (at this point).
Thanks for any pointer -
Alan
September 2, 2003 at 10:44 am
MDAC is just the data access code, not the storage itself. You could install and use MSDE for the local work, or you could look at getting SQL Dev edition - I think $49 a copy right now (included with MSDN subscription). If you're running under a server license you could also use SQL Personal Edition on developer machines.
Andy
September 3, 2003 at 12:13 pm
How should a SQL-Server database be copied to an MSDE environment ?? Does MSDE have a restore from SQL-Server capability?
Thanks
September 3, 2003 at 12:51 pm
Backup and restore, detach and attach. Be aware of the limitation of database size is 2GB in MSDE.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply