Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Halil416
Starting Member
5 Posts |
 Posted - 2006-03-07 : 01:21:21
|
| Hi I have a problem related with MSDE2000. I started coding @SQL SERVER 2000 + VB6 for a database program. Now I have to deploy it and trying to use MSDE2000. I have already a db file and no need to be recreated.I have been using DBAMNGR2k to connect the local server. There is NO connection problem but that does not list the my tables inside the db file. Is this a bug or is something missing?Can you explain me how to register database file to MSDE and how can I make the tables visible to my already coded program.???(NO code changes?) Is there a way to achieve this? |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-03-07 : 04:37:01
|
| Hi Halil416, Welcome to SQL Team!"I have been using DBAMNGR2k to connect the local server"Can you explain what that is pls"Can you explain me how to register database file to MSDE"I would recommend BACKUP from the original and RESTORE to the (new) MSDE.You could also DETACH from original and ATTACH to the (new) MSDE. However there are potentially some pitfalls to this.You will also need to re-synchronise the User IDs in the database with the Login IDs on that server. (There is a simple process for this, ask if you are not familiar with it.)See also:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=RESTORE+syntaxfor details of the Restore Syntax and Examples"how can I make the tables visible to my already coded program"There should be nothing you need to do, but it MAY be important (to satisfy your "NO code changes" criteria) that the existing tables are owned by DBO (i.e. and NOT by some specific user)Kristen |
 |
|
|
Halil416
Starting Member
5 Posts |
Posted - 2006-03-07 : 11:47:59
|
| thanx for reply... DBAMNGR2k (actually DBAMGR2k.exe) is a GUI for valid MSDE installations.It gives a handy tool to edit/manipulate/manage db files within MSDE structure.It is a matter of fact that I must use DBAMNGR since I am not familiar with MSDE.By the way here is the situation. I have made a program in VB6 + SQL2000SERVER. The program works fine on SQL2000 Server, However I have to migrate that program and its database to another notebook. I have even no idea how MSDE console works,so I used DBAMNGR, but the GUI cannot get the tables inside the db file. Or maybe there is sth else I may have skipped.Now back to the old fashion but reliable method, I need a procedure of MSDE commands to attach my old tables and db file to new instance of MSDE. I wonder if any one could help me on this on issue. |
|
|
|
|
|
|
Urgent - MSDE OK but does not see tables