Managing Live And Develop Database
Dec 7, 2006
Hello,
I haven written a Windows program in Visual Studio 2005. This program stores data in and retrieves data from a SQL Express database. The customer is starting to use the program and filling the database with data. However the program is still under construction (new functionality will be added) and so is the database (new tables, views etc. will be added).
Of course I could send the customer the new database, but than all data already entered will be lost.....
I'm thinking about using the SQL Management Studio Express and VS2005 to connect remotely to the database (a VPN connection is availabe) but worry about performance issues.... Or should I use some kind of replication / synchronization and how, because this is new to me.
What is the best way to solve this 'problem' ?
View 5 Replies
ADVERTISEMENT
Aug 27, 2007
Now, the developement in SqlServer Clr is obviously different from the develop in normal programs. there are many limitation in Clr develop, and it take many work to use dll alread exsits in Clr develop.
I do know that some limitation is reasonable, BUT much more limitation should be removed.
For example, now in order to use enum that exists in old dll in sqlServer, we have to create a new project and write many similar class to wrap the old enums, it's very troublesomely and slow!
so pls make the develop model consistent as possible.
View 3 Replies
View Related
Jul 27, 2006
i have install vs2005 and wm5 sdk on my pc. i want to develop database application on my pocket pc (database = sqlserver 2005 express)
- i need to install another software on my pc or pocket pc ?
- how to start develop database application on my pocket pc?
thank you
View 1 Replies
View Related
Aug 6, 2015
I want to restore a database (from an encrypted .bak file) - but *not* over the live original if you take my meaning. Encryption is the standard AES-256 that comes with Sql Server 2014 btw. I don't want the original touched/altered in any way. I would like to capture a success message if possible.I can extract the physical device name of the database in question using the following code:
SELECT physical_device_name, *
FROM msdb.dbo.backupmediafamily
WHERE media_set_id =(SELECT TOP 1 media_set_id
FROM msdb.dbo.backupset
WHERE database_name='MyDatabase'
AND type='D'
ORDER BY backup_start_date DESC)
I would like if the newly restored database was rename to something different than 'MyDatabase' (as shown above) and has different logs than the original. If possible, and capture a success message when restored.
View 5 Replies
View Related
Aug 11, 2007
I am developing an office automation software for a government department. To start with, I have decided to first automate the salary section of the department. Because of some issues like, TCO, easy support and maintenance, scalability etc., I have decided to use SQL Server 2005 database with VB 2005 front-end.
I have planned the layout for this first part and found that in only employee salary table, 40,000 records per month will be stored. That comes out to be around 480,000 records annually. This is for one table alone, excluding data in other tables.
Since each section of the department will be integrated into this later, this application will become the backbone the department. The employee service, leave, salary, allowance, deduction and other records shall be maintained.
For this type of mission-critical application, I want to get some queries cleared:
(1) What backup strategy should be followed? I want to have schedule and maual backups both. Is there any way to have a mirror image on another server?
(2) What considerations to keep in mind in the inital stage of database design?
(3) How to keep the design scalable and configurable to meet future needs?
View 6 Replies
View Related
Jun 26, 2006
we have a group of developers which have created and asked us (DBAs) tocreate many objects in the databases including tables / storedprocedures / functions / etc.since our company is growing, however we have an increasing amount ofobjects that have either been abandoned or have several versions.in an effort to clean of the huge amount of clutter and anytime thatsomething simple like a stored proc needs to change, it is almostimpossible to predict exactly where we will see negative effects ofthis change.i am looking for a system (preferably without developing our own tool)that would keep track of history of database objects (in terms of whocreated it and what purpose it has) as well as link that to all thedevelopers/users we might need to notify of any changes to that object.Also, this should be linked to the application which rely on theobject.bottom line... every object in the database needs to have at least 1corresponding contact as well as the applications which us it.with this information, we can much more easily maintain objects in ourDBs.thx
View 3 Replies
View Related
Feb 1, 2005
have 2 databases in sql server 2000
Live
Dev
I need to append all the data from LIVE into DEV environment. I have tried using MS Access (linking tables & importing tables and running APPEND query to update the rows from LIVE to DEV but PK & FK is causing problems as some data will have the same ID's....
Could I use DTS--Access wizard in SQL Server.
What is the best option to use?
Thanks all in advance
View 2 Replies
View Related
Oct 19, 2006
I have a live SQL 2005 database that has ntext fields, when the ntext fields go over 4000 chars the record can no longer be edited. It throws a string or binary data would be truncated error. I tried turning text in row OFF, but it did not work. Can anyone forsee any problems with changing the ntext fields to nvarchar(max) in the live database? Also, I came across sp_tableoption N'MyTable', 'large value types out of row', 'ON', does this work for ntext also? sp_tableoption N'MyTable', 'text in row', 'OFF' did not do anything.Any help would be appreciated.
View 4 Replies
View Related
Aug 2, 2007
hi.
I would wish to know whether it is possible for me to program the code from html or aspx ( from web hosting server ) to our office intranet database which is window server 2005?
I had tried to google for more info but there are too complicated thing for me to understand.
Actually i am doing the web form feedback form from the website for the public to fill in and submit. i am using the mysql from web server to store the records from the feedback form.
We have another database in our server, ms server 2005 to store records in the intranet office only. i need to get the records from mysql to intranet database. i don`t think there is a automated scripting which allow u to auto update the intranet database from mysql( web server )
So i thought of one thing . program html or aspx to insert records directly to our database intranet . but how ?
I appreciated that.
Regards
newbie on aspnet.
View 3 Replies
View Related
Feb 5, 2008
Hi,Ive been building a project on a local server and now need to transfer the files and database over to the live server. I have managed to transfer the files quite easily, however I am having a few problems transferring the database using Microsoft SQL Server Management Studio. When I try importing data to the live database, all the data and tables are brought across however some of the values for the fields are lost. For example all the fields which had a primary key no longer have one, and all the set default values for the fields are also lost. Ive been considering just going through every table in the database and re-entering the correct values for the fields, but this seems a bit time consuming and I'm also concerned about possible errors which could arise as there will be an inconsistency.Another method I tried was copying the SQL query across which created all the tables and the correct values for the fields. However when I tried to import the data an error was produced as you cannot import data into a table which has read only fields etc..Does anyone know a solution?Thanks for your time.
View 2 Replies
View Related
Mar 23, 2006
im using the the login controls with asp.net
when i test locally everything works great, its see the ASPNETDB.MDF file, checks the login info and passes the user on to the next page.However when i move the application to the live server it fails, it cant find the datasource that contains users/password etc. here is there error:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) So im missing something here, im used to connecting directly to a remote SQL database and accessing the info from there.
Can someone point me in the right direction? Can the MDF file not be used off the server itself without SQL express installed? Do i need to migrate those tables into a real SQL database?Thanks,Sean
View 2 Replies
View Related
Jul 31, 2007
Hi
I'm migrating from access to sql server 2005.
With access, I did full backups every 6 hours, by simply copying the .mdb file to a folder on another hard disk on the server, and then ftp it to a distant server.
I guess i just can't simply do the same with the SQL server .mdf file.
What is the best practice to achieve the same goal ?
Thank you
View 9 Replies
View Related
Sep 11, 2007
I'm not sure this is the exact forum in which to ask this question, so if there is a more appropriate forum, please point me in that direction.
Basically I'm looking for advice and best practices for dealing with an upgrade plan for a hosted database. Here is the situation:
- Hosted software application (.Net)
- Uses SQL Server 2005
- When we upgrade the software application to a new version, there will be schema and data changes that need to be applied to the database
- For the software application, we have considered upgrading an offline machine and then switching old one instantaneously.
- For the database, I'm trying to figure out if we can keep everything live for upgrades, or if we should have a small amount of scheduled downtime to upgrade.
So we have identified 2 basic directions:
1) Keep the database live and apply the new script changes just after the application software is upgraded. This means zero downtime, but we'd have to design and test our application to be backward compatible, so that the new version of the application code could handle both the new schema design, and the old schema design. It seems that this option would add a huge amount of complexity because we would essentially be testing a 3rd app/schema combination.
2) Take a small amount of scheduled downtime and upgrade the application code and database all at once.
Obviously option #2 is the most desirable from a development process point of view, and #1 is the most desirable option from a business point of view (zero downtime).
So, I'm looking for some advice on this. Do most people take the whole system down? Are there 100% live systems that deal with this? Are there other approaches I'm not considering?
Any information would be greatly appreciated. Thanks.
View 4 Replies
View Related
Jan 31, 2015
I want to Replace The Big Log database with A new one ( A database with same structure).But current DB has many connection .
This is my plan :
1- Create a new database with same structure.
2- Rename current database to olddb with this code :
USE master
GO
EXEC sp_dboption CurDataBase, 'Single User', True
EXEC sp_renamedb 'CurDataBase', 'OldDataBase'
GO
3- Rename Newdb to current DB.
USE master
GO
EXEC sp_renamedb 'NewDataBase', 'CurDataBase'
is it true ? and Tsql code is ok ? (dont forget many of connection to curdatabase (that Is a log db) and loss some seconds data is not problems)
View 4 Replies
View Related
Oct 7, 2015
Client is running X- version of application and corresponding database size is huge. Now client's vendor is releasing Y-version of same application with many database schema changes (like new tables added, new columns added, renamed existing columns and etc) To upgrade to the Y-version, vendor is suggesting to my client that down the system and do the upgrade for application/database to Y-version. We are sure that this process will take days together to upgrade to the Y-version. My client is not ready to down the system for that long. So we are trying to find the solution with minimal down time.The approach we are thinking is,
1) Create the replicated database to another server (server2) from production server(server1) using golden gate with X-version
2) Create new tables/schema updated tables from Y-version database on same server1. Here for Updated schema tables we are planning to use the name <table_name_Y_version> as the same table name exists in X-version.
3)With above 2 steps, golden gate replicate the changes from production to server1 and server1 will have the new Y-version table schema (with different concatenate name ' _Y_version'). BTW , there is no affect for the production
4) At this stage we are planning to find best approach, to fill the '<table_name>_Y_version' from X-version tables. two challenges here a) all data needs to be moved to Y-version tables b) they have to sync data in real time.
we thought of going to
a) ssis package to pump the data to Y-version tables, but real time data will not sync.
b) trigger based technique, previous experience said, lot of load
c) thinking about sql replication.
View 5 Replies
View Related
Dec 27, 2006
Live Webcast tomorrow
Essential Team System for Database Developers
1 PM Central time 12/28
https://www.clicktoattend.com/invitation.aspx?code=112602
View 2 Replies
View Related
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
May 3, 2008
Server A = primary SQL DBs (mirroring origination)
Server B = failover SQL DBs (mirroring destination)
For database mirroring a witness is required.
Can the witness live in another instance of SQL on server B?
View 7 Replies
View Related
Feb 16, 2001
I have to design, load and write scripts for a remotely hosted SQL 7.0 Server.
My desktop computers are both Windows 98. What do I need to develop and publish databases from my desktop to the remote host? I have always had the luxury of having direct access to the SQL Server and cannot find any conclusive guidance at Microsoft's site.
Thanks so much for your help.
View 2 Replies
View Related
Jul 26, 2007
Hello all,
I've looked through this forum and haven't found an answer to my question, but I'll make this short and sweet, as I know your time is valuable.
I've taken a MS Access database and turned it into an SQL database for our server, it works. However, I want to make an identical database (to distribute to 30-40 employees) in SQL CE, so that employees can work on their laptops offline and sync their data to the main database when they return to the office. Am I going in the right direction, or is there a better way to do this?
I won't bother you for a step-by-step, but any and all info/guidance you could provide would be of great use to me.
Thanks for your time!!!
CG
View 3 Replies
View Related
Sep 7, 1999
I have a table which stores the following data:
Col1 Col2
A Apple
A Orange
B Pear
C Banana
C Tomato
C Apple
C Pear
I want to display it in the following manner using a SELECT statement.
Col1 Col2 Col3 Col4 Col5
A Apple Orange
B Pear
C Banana Tomato Apple Pear
Can anyone help me figure out this SQL Statement.
Thanks,
Tim
View 2 Replies
View Related
Sep 16, 2015
I am trying to develope a authorization matrix for cpmpany of 75 employees, with different roles and permissions for roles to some applications like CRM , diiffrent folders,databases etc. I tried to find some informaton about this auhtorizaion matrix.
View 0 Replies
View Related
Mar 12, 2008
Hello,
I heard from someone that sql procedure can be created by some sql server tool. So if i am using a sql 2005 or 2000 , how i can create a custom stored procedure. ?
thanks,
View 1 Replies
View Related
Nov 1, 2007
Hi,
This is my first message in this forum. I am a University Student. I have to develop project that compares two databases objects then finds differences between two databases. Then project must synchronizes two databases. This project is similar with Red Gates's SQL Compare 6. I couldn't find any idea to start developing this projet. Is there anybody that has any idea?
View 6 Replies
View Related
Mar 27, 2007
This isn't a performance type of question, or whose CPU is bigger, but I'm more interested in knowing what people use out there as far as monitor setups go.
The root of the question stems from working in large package where there are many components laid out on the work flow. What do you use to work with large layouts? I constantly find it troubling to view enough of my package and am always zooming out to see more of the package. However, when doing that, the text becomes unreadable, of course.
I currently use a dual-monitor setup using my laptop and a LCD flat screen.
Resolutions on the laptop is 1920 x 1200 and the LCD monitor is 1280 x 1024. This helps to keep windows and output screens on one monitor while keeping the work flow on the other. Even still, I wish I had more screen real estate.
So, what say you?
View 6 Replies
View Related
Jun 2, 2006
Hey everyone,First off, sorry if this has been asked and answered before--I've tried searching the forums but may have just not used the right criteria. Anyways, I'm new to .net and all that stuff, and I was wondering if there were any differences (code-wise) between developing on 2005 Express and running on SQL 2000. I know there would be variations in the connection string, but I wasn't sure about anything else--specifically if they both use the sql provider thingy (I forget the name of it, since I don't have my book in front of me). I don't expect there to be many differences, but I wanted to check before I got too deep into coding.Thanks in advance.
View 1 Replies
View Related
Oct 13, 2007
Just placed the SQL Server 2005 - Developer Edition into my Drive...
I get prompted with the following options..
This DVD contains 32-bit (x86) and 64-bit versions of this edition of SQL Server 2005. Click the link that matches your environment to begin
x86-based operating systems
x64-based operating systems
Itanuim-based operating systems
I'm new to SQL Server... I just need to start learning how to use it... because it is being used at work... Don't need the all the features installed, just the normal table and query for the moment...
I will be installing it on my PC... i
Microsoft Windows XP - Home Edition - Version 2 - Service Pack 2
My local Hard Drive remaining capacity is 12.6GB
External Hard Drive remaining capacity is 11.0GB
Tried looking everywhere for the answer... lol (even looked at YouTube for a simple installation video....
Thanks for your help
View 14 Replies
View Related
Apr 17, 2007
Hi, anybody help me how to develop Today Screen plug in for WM5 pocket pc.
View 1 Replies
View Related
Feb 3, 2006
Can I develop applications with SQL Server Express that I have more than one user in several computers working with the same database on a server, or I can only develop applications with only one user with a local database with SQL Server Express?
View 3 Replies
View Related
Mar 26, 2006
Anyone out there developing or modifying packages w/ C# and the SSIS objects that I can compare notes with?
Thanks!
View 18 Replies
View Related
Jan 10, 2008
Hi,
just wanted to know,
Is it possible to deploy a report develped by 2008 on to ssrs 2005 server, if so does it work fine.....?
View 3 Replies
View Related
Sep 10, 2007
I have developed a renderer that renders the xml to paint a rectangle with textboxes in all the right places based on the data retrieved off the database. When i render the a complete report to the reportviewer i have no problem.
I need however to render the rectangle into a custom report item for reusability and different scenarios. This just seem to be impossible since it seems like I cant use anything other than an imagemap to render custom report items. Is this true?
To make sure you understand....in other words....
Is there a way to develop a Microsoft.ReportingServices.ReportRendering.IRenderingExtension that renders the required xml like rectangles/textboxes etc. and then migrate this to a custom toolbox item. It just seems like this should be a very easy thing to do and something regularly needed. For example when you want to use textboxes in certain positions within a rectangle to draw a organisational chart.
View 3 Replies
View Related
Nov 30, 2006
Hi all,
I've finally received my first official assignment using vb.net and SQL Server.
I have been developing / learning with both on the express editions.
I've also just run into some issues trying to access a SQL Server 2005 Express .mdf thru
SQL Server 2005 Pro.
We just couldn't get it to open. Connecting or Attaching etc...
We had to install SQL Server Express on the other PC to get it to open the SQL Server 2005 Express .mdf.
---
Now that I am ready to develop in ernest, I would like to setup my own controlled development environment.
Our target is a winforms application with a SQL Server 2005 Database for WinXP or Vista.
I'm ready to purchase Visual Studio 2005 Pro once I figure out the best development environment and SQL Server Version.
Specifically, once I've developed my winforms app, what issues do I need to consider to install a SQL Server 2005 database server / engine on a client / users machine?
Can I use the SQL Server 2005 Express?
Or perhaps there is an MSDE equivilant for 2005?
I can't seem to find any info regarding installation procedures for SQL Server in this regard.
(Perhaps its because I'm using the express editions?)
Any positive contructive help would be greatly appreciated.
Thanks,
Barry G. Sumpter
View 1 Replies
View Related
