[MS SQL Server] Data copy |
| Posted: 26 Jun 2013 05:48 PM PDT Hi,I have been looking around bu tnot found what I am looking for as yet...I have a production system that has the underlying database built by the application. All thables, indexes, constraints etc are all there. My porblem is that the currnet db seems to be dodgy and I need to get all the data out and into a vanilla database with all the pre built stuff - any ideas as how to get around all the constraints - pks and fks etc ?Appreciate any and all ideas. |
| Posted: 26 Jun 2013 07:18 PM PDT Hi,In sqlserver ,If a column is declared as TIMESTAMP, can we specify to capture the date / time as Universal Coordinated Time (GMT) ?Are there automatic routines that run to synchronize the Server's Clockto the Naval Observatory's master clock? For TIMESTAMP datatypes, is the TIME ZONE automatically included with the date / time or must this be specified manually?Thanks |
| Posted: 26 Jun 2013 08:01 PM PDT we have an online payment applicationExample: A customer in India pays in Rupees on one transaction,another customer in the US pays in Dollers.For CLOUD implemented databases where a server can exist anywhere in theworld, and transactions can come in from anywhere, can the database be set upto store money in currencies specific to each transaction? |
| Moving from Standalone to clustered SQL Posted: 10 May 2013 06:44 AM PDT Hi -We have a standalone SQL box that we need to migrate all the DBs to a new clusted environment that we will be building. The storage team with me detaching the existing storage desks from the standalone to the clusered servers so we do not move databases, just attach them back to the new clustered servers. The question I have is howto handle the system databases. From some links I see that others recommend restoring system databases, and then attaching the databases. Can you please tell me what is the best way is to handle the master database? Do you restore the master first, then do msdb and model DBs afterwards? The two new nodes we have need to be clustered? Is it better to first make the two nodes set as clustered and then have the storage team do the actual attachments to disks the day we go live?! What is the best way to set the clustered environment? |
| Posted: 26 Jun 2013 07:08 AM PDT When a database is upgraded from a SQL Server 2000 instance to a 2005+, if its compatibility level is raised to 90+, can the page and row counts still become inaccurate (after DBCC UPDATEUSAGE) since it came from SQL Server 2000?I understand the counts can be off a little bit for any compatibility level if a database is subject to many DDL changes, but I'm interested particularly in whether it is worse for databases from 2000.That's the impression I get, but can't seem to find a definite answer.Thanks! |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment