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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-26 : 08:33:37
|
| Sue writes "Hi. We are attempting to convert a Sybase SQL Anywhere 5 database to a SQL Server 2000 database. Once we get that happening, we will then be attempting to access this database using an existing PowerBuilder 5.0.04 application.We created a "blank" MSS database on a Windows 2000 machine. We then used PowerBuilder pipelines to create and populate tables based on the "source" SQL Anywhere database into the MSS database. This seemed to work fine and we can "see" the tables in the MSS database on the machine on which the database was created.We have since taken a copy of the MDF file, attached it to the default (local) SQL Server on another machine and attempted to use the database. On this second machine, we are using the sa login but when viewing the list of tables in the database, only the system tables appear and any attempt to access the required tables using SQL returns an "invalid object" error.Any ideas?? Does this have anything to do with the logons used for the creation of the tables??Thanks in advance." |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-09-26 : 11:59:56
|
| I don't know much about PowerBuilder, but to move databases to another server you need to detach and then reattach both the mdf and ldf files.Look up sp_detach_db in Books Online. |
 |
|
|
|
|
|
Not able to see tables created using PowerBuilder pipelines