3 Antworten zu diesem Thema

[wdcurry]

I honestly never expected this eStore to resonate so well with me (despite the affiliate issues). Thusly, i setup my first eStore with the internal db. 

Now, given that i am a longtime date-modelling expert, software kinda guy, i want to use sql server and my own abilities to fill the gaps. I absolutely need a sales report that is affiliate aware, quickly. I can do all this easily in SQLServer.. 

 

What i seek here is help or guidance in getting the internal db exported into SQLServer so i can carry on. I will shut down the store during the transition of course, and hope this thread serves to guide others.

Thank you. (and support staff: all my questions should both help other newbies AND lead me into being a paying customer) ..

 

drew..

[Marcus Gesing]

help or guidance in getting the internal db exported into SQLServer

 

There is a tool called "Microsoft SQL Server Management Studio" that supports attaching a SQL database file

to a running SQL Server. Right click Databases -> Attach. To get the local path of a database file right click

the database and then properties. Another Management Studio scenario would be a backup and restore.

[wdcurry]

Thanks Marcus, i am well-versed with SSMS.. i simply didn't know what the "internal db" was. I will address this later today for testing.. cheers!

[wdcurry]

man, opening an .sdf file in a Windows world was a challenge. (more of a mac guy now) .. Finally had to use VS2012, Tools, Connect to Database to make it happen. 

I see that AffiliateId is already in the order table. Do we currently have any easy way to produce reports or customize existing ones with the app?