Community
Showing results for 
Search instead for 
Do you mean 
Reply

SQL Server Management Studio import export

Copper Super Contributor
Posts: 128
Country: USA

SQL Server Management Studio import export

can SQL Server Management Studio be used to  import export a act database

provided of course you have all the right version and licensing

 

 

thanks

server stats: Ms Svr Std 2k8, Ms SQL Svr 2k8 R2 build 10.50.4302, ACT! Premium (Web) 2014 v16.0.291.0_HotFix5, 16GIG Memory
http://www.act.com/support/getting-started-documentation
http://www.act.com/support/downloads/act-premium-v16
http://kb.swiftpage.com/app/answers/detail/a_id/36097kwAdministrator%27s%20Guide
Copper Contributor
Posts: 29
Country: Germany

Re: SQL Server Management Studio import export

Hallo,

 

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:

http://www.crmaddon.com/en/addons-en/act-addons/data-management/import-it

http://www.crmaddon.com/en/addons-en/act-addons/data-management/export-it-act-2009-and-higher

 

best regards,

 

Susanne

Copper Super Contributor
Posts: 128
Country: USA

Re: SQL Server Management Studio import export

thanks for your reply

i just spend a 100 hrs in review of such add-ons and functions.
and have made a purchasing decision.

but my question still stand can it be done or not??
server stats: Ms Svr Std 2k8, Ms SQL Svr 2k8 R2 build 10.50.4302, ACT! Premium (Web) 2014 v16.0.291.0_HotFix5, 16GIG Memory
http://www.act.com/support/getting-started-documentation
http://www.act.com/support/downloads/act-premium-v16
http://kb.swiftpage.com/app/answers/detail/a_id/36097kwAdministrator%27s%20Guide
Copper Contributor
Posts: 29
Country: Germany

Re: SQL Server Management Studio import export

Hallo,

 

it should not be done, because it can destroy your whole database,

 

best regards Susanne

Copper Contributor
Posts: 27
Country: USA

Re: SQL Server Management Studio import export

 

 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.  

 

 

 

 

Bronze Super Contributor
Posts: 1,679
Country: Australia

Re: SQL Server Management Studio import export

Microsoft used to preach that Best Practice was to use a named SQL instance. Therefore ACT7 instance.

Copper Contributor
Posts: 27
Country: USA

Re: SQL Server Management Studio import export

 

But it was still the choice of the DBA.  And should be.    No such choice with Act! , Instance or bust.