Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Moving from File to SQL
#1
Hello All,

Are there any instructions to move from a File based environment to an SQL based environment, I have tried it but have lost all the connection credentials. The credentials and connection are there, but no credentials on the connections.

Thanks,

Bill
Reply
#2
Which version are you using? And what did you try? Export all, create a new database environment, import all - then it should work for the logged on user...
Regards/Gruss
Oliver
Reply
#3
Version is 2017, 10.1.5713.0

I did the steps that you described.
Reply
#4
Hi Bill,

I think I know the effect. That was indeed a problem we fixed in ASG-RD2018 ! So the best would be to upgrade to the latest version to receive that update. However the credentials should be visible but they are not assigned. So you have to reassign them then the connect should work again like before.
Best regards,
Michael
best regards,
Michael -- michael.scholz@asg.com --
Reply
#5
Yes, upgraded to 2018 and the import worked
Reply
#6
Thanks for your quick and positive feedback :-)
best regards,
Michael -- michael.scholz@asg.com --
Reply
#7
Now that I have moved from File to SQL, how can I share that SQL file between a couple of my machines, currently it is using windows account integrated authentication with my local machine, I don't use a domain, all of my machine are connect to my Azure Active Directory.

What do I need to do to share the SQL between my other machines?
Reply
#8
Hi
the other machines simply need to setup a database environment with the same entry as yours and need an account that has access to the Database. If you right-click on the Azure environment entry in the Environment Manager and choose "copy" then you have the connection-information for the database. Copy that to the other machines and use it as "connection-string". But you have to make sure they use valid credentials that are allowed on that azure DB.

Hope that helps,
best regards,
Michael
best regards,
Michael -- michael.scholz@asg.com --
Reply




Users browsing this thread: 1 Guest(s)