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 - 2006-06-05 : 10:13:40
|
| Abder writes "Hello allWe have an engineering application (auotodesk WorkCenter) using SQL server 4.21 runtime version. The application is no longer supported by its original provider. We would like to migrate its data to a new application. However, we are struggling with the data extraction. We have lost the password of the extraction tool provided with the application!!!Is there any mean to access the database thru another tool using the login and password of any user that has been working on this application?Your help is very appreciatedRegards" |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-05 : 12:16:47
|
| Is the system making backups?One option might be to freshly install SQL Server 4.21 on a different machine, and restore a backup onto it - that would get you a new SystemAdmin user & password.However, in SQL Server 6.1 you needed to know the size and number of each extension to the database, and recreate the database exactly the same before restoring - and that would require running some queries against the original database. Not sure how important this point is, might just be one to watch out for.From there you could perhaps upgrade to SQL Server 6.1, and from there to SQL Server 2000; or export the data [to one file per table] using BCP.I remember SQL Server 6.1, but not much before that that!Kristen |
 |
|
|
|
|
|
SQL SERVER 4.21 runtime version