Showing posts with label build. Show all posts
Showing posts with label build. Show all posts

Wednesday, March 21, 2012

I want to build a Directory... How what approach should I take

I would like to build a business directory like yellow pages but a whole lot smaller for my home town. How should a approach this?

Thanks much!

Probably as a web site, which means you need to ask at www.asp.net, instead of here.

|||Yes I'm sorry, I will be buildiing a site based on xhtml, css, asn some asp.net for the dynamic functions but as for the database, what approach should I take in starting to build the database, would it be possible to build a database with limit knowledge of building one?

Thanks!|||

Like anything, the less you know, the more you need to learn. I'll move this to the SQL Server forum where it belongs then. I would recommend however that your question is too broad. You're asking someone to design your database for you, if you're asking anything. I'd recommend just getting in there, doing some reading, coming up with a design and asking specific questions ( in the right forums )

Monday, March 19, 2012

i want help to build a application that will load data in msolap

Hi ,
i am new to msolap , i want to make an application that will update data or
insert data in msolap.
Any link , help ,book,sample program will be helpful .
thanks in advance .
kjangirHere are 2 books
Microsoft(r) SQL Server(tm) 2000 Analysis Services Step by Step
(http://www.amazon.com/exec/obidos/A...link%5Fcode=xm2)
Professional SQL Server 2000 Data Warehousing with Analysis Services
(http://www.amazon.com/exec/obidos/A...link%5Fcode=xm2)
Also take a look at the MS OLAP newsgroup
(http://groups.google.com/group/micr...sqlserver.olap)
and the MS Datawarehouse newsgroup
(http://groups.google.com/group/micr...r.datawarehouse)
http://sqlservercode.blogspot.com/|||Which version of Analysis Services: 2000 or 2005?
When you say "update data or insert data", are you referring to:
.. loading source data into SQL Server fact tables
.. processing the dimensions/cubes from the fact tables
.. changing the underlying values stored in the cubes (write-back) ?
Best Practices for Using DTS for Business Intelligence Solutions
http://msdn.microsoft.com/library/d...ntbpwithdts.asp
Loading Data into the Data Warehouse Database
http://msdn.microsoft.com/library/d...r />
_88it.asp
Building and Processing Cubes
http://msdn.microsoft.com/library/e...>
ack_9xsx.asp
"kuldeep kumar" <kuldeepkumar@.discussions.microsoft.com> wrote in message
news:A19E2425-397D-419C-88C2-273F50C1801B@.microsoft.com...
> Hi ,
> i am new to msolap , i want to make an application that will update data
> or
> insert data in msolap.
> Any link , help ,book,sample program will be helpful .
> thanks in advance .
> kjangir

Wednesday, March 7, 2012

I need to generate the query to build a database ive designed. Please help..

I've registered with GoDaddy for my site. I've used Visual Web Dev 2005 with SQL Server Mgmt Express 2005 to create my database etc. Now with GoDaddy, I need to "recreate" the database on their server again, but I don't want to go throug the whole process again. I just want to use their query editor to generate the database online.

GoDaddy mentions a "personal-sql" file that SQL Server 2000 generates, but I can't find anything like that with what I have.

Thanks.

Did you try automatically generating the scripts?

In Studio Express, right click on your database.

Select Tasks...Generate Scripts...

You can also generate scripts on a table by table basis.