SQL Database Design In Changing Business Environment

Oct 20, 2007

I am running an application with an SQL database and it works fine. My question is about a customer changing his information. We will need to be able to produce copies of old orders/invoices even after that company's info has changed (e.g. he moved or changed the company's name).

Assuming he changes his company's name, for example, do I,

1. Enter him as a "new" company? This allows me to keep the old info in the database if I query the "old" name but does not provide any portability of "old" information forward to the "new" company like payment patterns, past orders, etc. since he is "new" and has no past.

2. Or do I change the record of the"old" company to reflect the "new" name? Here I can keep the "old" past under the "new" name but I now cannot retrieve an old document that reflects the "old" name.

3. Or, the third alternative is to export to alternative storage all the files of the "old" company and go to number 2 above?

I thought about copying the "old past" into a "new" customer but then I'd have double sales, receipts, etc and I just can't see an end to that debacle.

None of these sound like fun but I'm sure I'll soon have to do one of these. I can't be the first one to ask this and I'm sure there is someone out there who is smarter than me/has a more elegant solution. Any suggestions?

I also posted this to Small Business Development forum but thought the SQL guys might have another idea.

View 7 Replies


ADVERTISEMENT

DB Design :: Changing Database In Memory

Aug 27, 2015

I need to change the table codes to in memory optimized but every time I try to change I got an error message like you need to change database to memory optimize.

So, I try to change it  using this code:

ALTER DATABASE Coralreef_ ADD FILEGROUP Coralreef__mod CONTAINS MEMORY_ OPTIMIZED_ DATA.

When I used this  I got an another error:

Msg 10797, Level 15, State 2, Line 1..Only one MEMORY_OPTIMIZED_DATA filegroup is allowed per database.

So, How can I change database to in memory optimized database.

View 5 Replies View Related

How To Deploy Updated Database From Development Environment To Live Environment?

Nov 16, 2005

I have finished a change request from our client. I need to update clients' database with the one in developments.Here is the changes i made to database:Added/Changed some tablesAdded/Changed some stored proceduresAdded data to some dictionary tableThe data in clients' current database MUST be kept. So how can I merge the changed information to clients' database?

View 3 Replies View Related

Report Design Environment - Tool Is Slow!

Mar 5, 2008

Does anyone else have problems with the speed of the design environment for SSRS reports? We are using visual studio to create and manage hundreds of production reports (Oil and Gas).

It literally takes 5 seconds for the design environment to react to each change in the report layout. For instance, a common change is to reposition a text box, change the length, text, font size, font weight etc...:



Grab the text box - 5 seconds until designer responds - then reposition

Grab the edge to change the length - ditto

change text - 5 seconds for designer to "save" the change and allow next action....

blah - blah - blah....
So, performing the simple change above takes at least 30 seconds in addition to whatever time it took to edit the text box.

I've talked to the other developers using SSRS here and they all report that's "just the way it is".

Is this normal or is there an environment issue/setting we are overlooking.

Thanks, Mike

View 5 Replies View Related

Business Problem: Range Of Coverage Of Material Stocks / Need Help With Design

Mar 24, 2008

I'd like to display the our range of coverage of material stocks via SSRS. The underlying database provides all the actual stocks of our materials as well as the current and planned consumption. Now, my problems are the design, as I am not sure If I can realise it with SSRS, and the way of displaying the actual range of coverage as I have no future time informations.

Has anybody made experiences with reports like that?

View 6 Replies View Related

Changing The Design From Char To Datetime

May 1, 2005

I accidently put char instead of datetime in the Sql Server DateCreated
dataType. Is there any way that now I can change. I guess even if I
change I cannot get the time and date in a format that I want since
they are in Char datatype.

View 2 Replies View Related

Changing To Design View Of A Reporting Services Report File

Nov 13, 2007

When I am working on an Integrations Services project and I open a Reporting Services file, it displays it in the Code view. Is there a way to display it in the Design view? Or do I have to close the project and open up a Reporting Services project?

Fred

View 1 Replies View Related

DB Design :: Database Design For Matrix Representation

May 13, 2015

I have a scenario like below

Product1
Product2 Product3
Product4 Product5
Product1 1
1 0 0
1
Product2 1
1 0 0
1
Product3 0
0 1 1
0
Product4 0
0 1 1
0
Product5 1
1 0 0
1

How to design tables in SQL Server for the above.

View 2 Replies View Related

Installing VS2005 And Business Intelligence Report Projects On A Vista Business Workstation

Oct 23, 2007

Does anyone have a successful prescribed sequence for installing VS2005 and Business Intelligence Reports Projects on a Vista Business workstation to be used to create reports for a server?

I've looked through everything I can find here and I don't seem to see a clear solution without a lot of trial and error.

Fact is, I've not been successful getting just the reports to install on a plain XP box. Of course, the report creation looks fine on the server but I don't want to work directly on the server.


Thank you

View 1 Replies View Related

Synchronization Of Business Contacts In Outlook With Small Business Accounting

Jun 10, 2006

Can anyone take me through synchronization of contacts within Business Contacts Outlook into Microsoft Small Business Accounts?

I run a stand alone PC with NO network. When SBA came SQL was also installed. Apparently you can synchronise Contacts within Business Contacts with SBA but both SBA & Outlook should work through the same SQL server.

Has anyone tried this?

Can someone walk me through the process?

Thanks

Debbie

View 1 Replies View Related

The Database Environment

Jan 14, 2004

Hello, everyone:

What is difference between testing environment and product environments for MS SQL Server? Thanks a lot.

YTZ

View 1 Replies View Related

Database Design/query Design

Feb 13, 2002

Ok, I'm doing a football database for fixtures and stuff. The problem I am having is that in a fixture, there is both a home, and an away team. The tables as a result are something like this:

-------
Fixture
-------
fix_id
fix_date
fix_played

----
Team
----
tem_id
tem_name

-----------
TeamFixture
-----------
fix_id
tem_id
homeorawayteam
goals

It's not exactly like that, but you get the point. The question is, can I do a fixture query which results in one record per fixture, showing both teams details. The first in a hometeam field and the second in an away team field.

Fixture contains the details about the fixture like date and fixture id and has it been played

Team contains team info like team id, name, associated graphic

TeamFixture is the table which links the fixture to it's home and away team.

TeamFixture exists to prevent a many to many type relationship.

Make sense? Sorry if this turns out to be really easy, just can't get my head around it at the mo!

View 2 Replies View Related

Need To Get A Copy Of A Database From One Environment To Another.

Mar 4, 2008

Hi,

I have been experiencing difficulties achieving the above.

We have a secure network environment and the connection can only be established from within, not from outside, so basically, there is a rule that allows me to go outbound on port 5022 to our other network.

There is no domain trust relationship, so I have had to create Certificates and use these as the method of authentication.

I have managed to get this working on two other environments where there is two way communication enabled on port 5022.

I thought I might be able to fool it into forcing the mirroring without two-way communication by setting up mirroring in the environment and using the hosts file to change the actual IP address of the server, this didn't work. The mirroring monitor thought that mirroring was still active, but on the other server, the state never changed and was just waiting for something to happen.

I also thought I might be able to turn the transactional safety off, but only to find out that this can only be enabled in the Enterprise version of SQL Server.

The reason why I have been trying to get mirroring working this way, is due to a requirement for an encrypted connection, I know that with SQL Server mirroring you can choose the encrpytion method and the plan was to create snapshots of the database in the other environment, just so we could access the database.

I think we're at a stage where we will be willing to explore other possibilities, so if anyone could point me in the right direction, it would be greatly appreciated.

Please bear in mind, that we're not concerned with redundancy, this is purely to get the data from one point to another.

Thanks,
Akeel.

View 3 Replies View Related

How Can I Back-up My Database In Production Environment.

Apr 24, 2007

I developed an asp.net application in visual web developer 2005 express edition and SQL sever 2005 express with Advanced services. The application has been deployed and iam wondering what tools are availabel to for backing up my data. Are there any tools i can use to back-up my database. Iam not talking of third party tools but tools a vailable in sql sever 2005 express with advanced services or visual web developer express.
OR can write a vb.net Sub procedure that i run and have my database backed up. If so where can i start or what other options may i explorer.  

View 4 Replies View Related

Database Backup In Cluster Environment

Aug 7, 2000

Hi Everbody:

I would like to know your experience about how to make regular database restore and point-in-time restore in SQL Cluster environment.

(1). My first question is about database backup. We use SQL Server backup in our shop. We hope that we can back up the database to a one network shared drive. The SQL Server can not do it. It only allows us to back up database to the local drive. Since there is no too much spaces in the local drives (C, D and E), I would like to know how we can back up to the network shared drive.

(2). A few database are critical databases which require point-in-time restore. How we can back up database (complete backup or differential backup), transaction log?

(3). If database and transaction log crash at the same time, can we still do point-in-time restore?

(4). How we do Master DB and MSDB back up? Weekly or monthly?

Thank you very much for your advice.

Joan

View 4 Replies View Related

SQL 2012 :: Shrinking Database For Dev Environment?

Nov 26, 2014

I've read lots about why you shouldn't normally shrink databases in posts such as this:

[URL]

But we have a situation where we are required to copy the live db to various non production environments for testing. Part of this process involves truncating a number of tables with masses of blob data. So we're freeing up quite a lot of space. The question is how to reclaim this? The database is peculiar in that it's got no clustered indexes so I can't rebuild indexes on another filegroup with drop to move and rebuild.

I've tried dbcc shrinkfile specifying a size. I've tried to shrink the file in increments. The problem is I'm just not getting much space released. I get maybe 2-3%. I suspect this is because we're dealing with heaps with some tables that have sparsely populated blob / image data.

Is there an alternative to shrinking? Should I recreate all the db objects in a new database? It doesn't matter if the process takes a while or if it has to be done manually.

View 7 Replies View Related

Restoring Database In A Clustered Environment

Jun 8, 2007

Can someone tell me how to make a backup in a sql clustered environment (MSSQL 2000) and how to restore that backup in clustered environment (MSSQL2005)? A step by step backup and restore procedure is appreciated.

View 5 Replies View Related

Create Database On A Sql Cluster Environment

Jan 28, 2008

How can I create a new database on a cluster sql environment? Do I need to create the database on both nodes?
Thanks in advance!

View 4 Replies View Related

Backup Sql Server Database In Hosting Environment?

Aug 11, 2006

I am new to database.
I have a website in a hosting environment and it uses sql server 2005 databases. I want to have a complete backup of my database in addition to the hosting company's routine backup.  I want to write a program to automatically backup everything every night. And of couse have the ability to restored the whole database if necessary.
How should I do it? Are there any tools exist that I can use? What is the best way to deal with backup/restore in hosting environment?
Thanks!
 
 

View 1 Replies View Related

HELP On Deploying A SQL Database To A Remote Hosting Environment

Apr 4, 2008

hi,I was redirect to this URL* based on Deploying a SQL Database to a Remote Hosting Environment,pertaining to my question on how do I convert MDF file to .SQL.I had downloaded and installed the program recommended that is Database Publishing Wizard.but the problem is now, there isn't any context menu "Publish to Provider" * when i right click on thedatabase aspnetdb.mdf..please advice me. thanks.* Reference : http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx 

View 4 Replies View Related

Database Environment Naming Production -vs- Development

Jul 23, 2005

I have been looking for some documentation that would support or rejectmy opinion on Production -vs- Development naming conventions. Ibelieve that each environment should be housed on separate servers withidentical names, access, users, stored procs....... If you eitheragree or disagree with this methodology, I would appreciate your input.TIA,Bill

View 5 Replies View Related

How To Copy A Database From Production To Training Environment

Oct 21, 2015

Our DBA is out for about 6 weeks. One of his regular jobs is to take a Database that is in our Prod environment and copy it to our Training environment.

I have backed up and restored to different servers before, however the Database name in Prod is different than in the Train environment in this case.

In other words I have a PROD database named DATABASE-XX that I want to copy to another SQL server and restore it to DATABASE-XX-TRAIN.

Is there anything special I need to do, other than backup on PROD, copy to TRAIN and restore to the corresponding DB in TRAIN?

View 11 Replies View Related

Sharing Website(asp.net) Mdf Database On A Network In Multiuser Environment

Sep 19, 2007

simple question:

I have create a web site in visual studio with form user authentication. Thats create a mdf database in this path:

c:inetpubwwwrootwebsiteapp_dataaspnetdb.mdf
thats use Sql server

i would like to access this database with c# form application on a network with multi-user.
if i change the drive letter of the path above to f: (mapped drive) or \serverc, i got this message


System.Data.SqlClient.SqlException: The file "h:InetpubwwwrootwebsiteApp_DataASPNETDB.MDF" is on a network path that is not supported for database files.
An attempt to attach an auto-named database for file h:InetpubwwwrootwebsiteApp_DataASPNETDB.MDF failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

i read that sql server did not support database sharing with mapped drive or unc share.

So how can i share website database with c# application???

Note: of course if i develop the website and the application on the same machine its work. I want this application run on several work station accessing all the same mdf database with his web user member.

View 7 Replies View Related

Problem Deploying SQL Express Database To Hosted Environment

Nov 2, 2007

I have a web app that uses two SQL Express databases. One of the databases is the membership database. I am deploying the app to a hosted environment. Here is my connection string:


<add name="Akamojo_APSNETDB" connectionString="Data Source=.SQLExpress; AttachDBFileName=|DataDirectory|Akamojo_ASPNETDB.mdf; Initial Catalog=Akamojo_ASPNETDB; Integrated Security=true; User Instance=true"/>


Here is the error that I get:

Could not open new database 'Akamojo_ASPNETDB'. CREATE DATABASE is aborted.
Cannot attach the file 'e:hostingmemberakamojoTournamentLogApp_DataAkamojo_ASPNETDB.mdf' as database 'Akamojo_ASPNETDB'.
File activation failure. The physical file name "c:inetpubwwwrootTournamentLogApp_DataAkamojo_ASPNETDB_log.LDF" may be incorrect.
The log cannot be rebuilt when the primary file is read-only.

The mdf file is not read only. In the hosted environment the database is on the E drive. In my dev environment the database is on the C drive. From the error message, it appears that when it tries to build the log file it is trying to build it on the C drive in a path that doesn't exist in the hosted environment.

Any help is greatly appreciated.

-Darrell

View 1 Replies View Related

Issue In Setting Up The Database Mirrioring Environment For SQL Server 2005.

Jan 30, 2006


Environment:SQL Server 2005 Enterprise in Win2k3 Enterprise on 32(x86) bit machine
I am able to enable the Trace Flag 1400 using DBCC TRACEON (1400) GO. Only then we can able to configure for the ENDPOINTS.
I successfully configured the ENDPOINTS for both the principal server and Mirror server .And then when I started the START MIRRORING.
I got the error message. Please find the Message below.
An error occured while starting mirroring.
additional Information:
:..>Alter failed for Database 'KQDB', (Microsoft SqlServer.Smo)
:..>An exception occured while executing a Transact-SQL statement or batch
[Microsoft SqlServer.Connection.info]
:..>Database mirroring Transport is disabled in the endpoint configuration.
[Microsft SQL Server,Error: 1486]

If anyone have a solution on how to setup a database mirroring environment.Please send.




View 10 Replies View Related

SQL Server Instances For Business Contact Manager 2007 Database?

Feb 26, 2008



Hi, i have created a database in business contact manager which is currently been used by five toher employees. I was trying to move that database to my server. Well I found this tool online called "Business contact manager 2007 database tool". I am trying to run it on the server but it is giving me a following error:

"Cannot retrive the list of SQL Server instances. Please make sure that SQL Server 2005 or SQL 2005 Express is installed and that the service is running."

I have SQL 2005 installed on my computer and I dont have any idea how to resolve this issue. It would be great if someone could help me.

View 1 Replies View Related

SQL Server 2014 :: Stored Procedure - Add A Record To Local Database Executing In Cloud Environment

May 20, 2015

Is there a way using a stored procedure in a local database to add a record to a database executing in a cloud environment when both entities reside in different domains?

View 2 Replies View Related

Quick Upgrade SQL Environment (Database Engine, SSIS, SSRS, Etc.) Exchange Hardware Plan

Feb 7, 2008

We have installation of Dbase Engine and SSIS that is PRODUCTION, and want to replace with newer hardware. In "the old days", we built "boxname_new" and installed SQL with "sqlname_new", took PROD users off-line, and quickly renamed original boxes/SQL and new boxes/SQL to original name, copied data and off we went with upgrade.



NOW, the "renaming" option for SQL tools is not supported, but with re-installation.



Has anyone developed game plan steps for accomplishing hardware upgrade, including SQL environment swap with MINIMAL downtime for PRODUCTION environment? Can you share?

View 2 Replies View Related

DB Design :: Buffer Database - Insert Information From Partners Then Make Update To Main Database

Oct 29, 2015

I actually work in an organisation and we have to find a solution about the data consistancy in the database. our partners use to send details to the organisation and inserted directly in the database, so we want to create a new database as a buffer database to insert informations from the partners then make an update to the main database. is there a better solution instead of that?

View 6 Replies View Related

Cache Database Structure (How To Detect If Database-design Has Changed..)

Feb 24, 2006

Hello everyone,I have a webcontrol that uses database-structures alot, it uses the system tables in SQL to read column information from tables. To ease the load of the SQL server I have a property that stores this information in a cache and everything works fine.I am doing some research to find if there are anyway to get information from the SQL server that the structure from a table has changed.I want to know if a column or table has changed any values, like datatype, name, properties, etc.Any suggestions out there ?!

View 3 Replies View Related

Designing A Database Within A Database... Design Question Storing Data...

Jul 23, 2005

I have a system that basically stores a database within a database (I'msure lots have you have done this before in some form or another).At the end of the day, I'm storing the actual data generically in acolumn of type nvarchar(4000), but I want to add support for unlimitedtext. I want to do this in a smart fashion. Right now I am leaningtowards putting 2 nullable Value fields:ValueLong ntext nullableValueShort nvarchar(4000) nullableand dynamically storing the info in one or the other depending on thesize. ASP.NET does this exact very thing in it's Session State model;look at the ASPStateTempSessions table. This table has both aSessionItemShort of type varbinary (7000) and a SessionItemLong of typeImage.My question is, is it better to user varbinary (7000) and Image? I'mthinking maybe I should go down this path, simply because ASP.NET does,but I don't really know why. Does anyone know what would be the benifitof using varbinary and Image datatypes? If it's just to allow saving ofbinary data, then I don't really need that right now (and I don't thinkASP.NET does either). Are there any other reasons?thanks,dave

View 7 Replies View Related

Knowledgeable Yet Simple Book For Database Modelling Or Database Design

Aug 16, 2007

Hi All,Can u please suggest me some books for relational database design ordatabase modelling(Knowledgeable yet simple) i.e. from which we couldlearn database relationships(one to many,many to oneetc.....),building ER diagrams,proper usage of ER diagrams in ourdatabase(Primary key foreign key relations),designing smallmodules,relating tables and everything that relates about databasedesign....Coz I think database design is the crucial part of databaseand we must know the design part very first before starting up withdatabases.....Thanks and very grateful to all of you....Vikas

View 3 Replies View Related

Changing Database Mail Host Database

Jan 26, 2007

Hi

I am trying to change the host database (MSDB) of Database Mail to some new database (say NewDB) and

unable to make DatabaseMail90.exe point to this new database (NewDB).

Is it possible to do this?

Thanks

Uddemarri

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved