Is it possible?
How about all dev in sql server then migrate to "production msde" using either DTS or bcp and DDL scripts?
Can you bcp in to msde? And is msde true client server?This is a start!
http://groups.google.com/groups?q=msde+database+restore&hl=en&lr=&ie=UTF-8&group=microsoft.public.sqlserver.*&selm=2l7qo3F9s4e1U1%40uni-berlin.de&rnum=3|||MSDE is the desktop version of SQL Server. It is limited in terms of only 2 Gb per database, and only 5 simultaneous active spids per instance, but those are the only significant limitations.
I don't remember if BCP is included in the executables, although OSQL.EXE definitely is. The Transact-SQL BULK INSERT command works just fine, and is simply a different interface to the same API that BCP uses.
DTS works on an MSDE instance without any reservations that I know of, other than the limitations imposed by MSDE itself.
-PatP|||Cool...so if they want this application to be distributable...should be no problem...right?|||No problem I can see. Don't overlook the easy answer if you can just detach the database and zip it though!
-PatP
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment