Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Migrating Datastore

Status
Not open for further replies.

oneworld

MIS
Sep 3, 1999
138
US
Is there a document that would give me information on migrating a datastore from Access to SQL2000?

Joe - a.k.a. Oneworld


 
You need to use the DSMAINT utility, and its pretty straightforward. The command is dsmaint migrate [{ /srcdsn:dsn1 /srcuser:user1 /srcpwd:pwd1}] [{/dstdsn:dsn2
/dstuser:user2 /dstpwd:pwd2}]

You will already have a new DB configured on SQL and a file DSN setup that points at it (dstdsn)

Check out the Presentation Server admin guide. If you are looking at the PS4 version, the Dsmaint command is explained on 368-371.

Hope this helps.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top