04-08-2014 03:41 PM
can SQL Server Management Studio be used to import export a act database
provided of course you have all the right version and licensing
04-09-2014 07:46 AM
please do not import and export data into Act! via SQL.
Act! has functions to run it and there are some Tools and Addons to do this job.
For example our IMPORT|IT and EXPORT|IT:
04-09-2014 08:15 AM
04-11-2014 06:15 AM
I have no idea why prevous responder wrote "because it can destroy your whole database", that's an obviouisly vague and inaccurate answer.
Of course SQL Server as a host DB service via Studio Manager should have no problems at all Exporting / Importing and Backup / Restore any database including Act's. Just have to make sure you get the DB objects Table+Logins+View+StorProcs, etc properly on the Import/Restore side. Client's PAD & ADF files will be to be repointing to new server/instance.
I too have been looking at v16 closely the last few days to replace a small v6 setup. I find v16's SQL setup to be way less then ideal, such as the need to have a separate instance (\ACT7). This fact alone hints that the SQL folks at Act! are not fluent in SQL. No where was I able to find WHY a separate instance is required, because there is no real reason. A peek at the DB table structure hints of years of mix-mash of various programmers and general disorganization of design, just like the pile of various files in the appplication's folders starrting at \Program files (x86)\ACT\ACT for Windows.
04-14-2014 04:23 PM