Hi,
Here is the situation:
My SQL server is in B'lore. I need to transfer the Database from the B'lore server to a new Server in California.
Kindly let me know how it could be done.
Thanks in advance.
Hey all!I am hoping that somebody will be able to help me getting my database working over the Internet.I am using VS 2005 and SQL Server 2005 Express Edition and have my database set up within a web site project in VS under the App_Data folder.Everything runs smoothly when running the application on localhost I am just facing a problem when I attempt the same thing after uploading my pages to my web server.I am receiving the following 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)I have tried enabling the disabled SQLEXPRESS protocols and disabled my firewall with no luck.I have also looked into using localhostsqlexpress as the server name but I dont see how this method would work as it appears to only run a database on the local machine which is the problem I have currently.Could anybody help me with this problem? I have only just started trying to use SQL Server Express as a means of database connectivity and I am not exactly sure how it all works.Thanks
Hi there!
I am fairly new to SQL Server 7. I have a SQL server database on one machine (box A).
Now I installed a new box with SQL server on it (box B).
How do I move the database from box A to box B?
What are the steps involved? What is the easiest way to do it?
What files need to be copied over?
Thanks,
Helmut
What is the best and safest way to move all databases(almost 500GB total) from our existing server(2000) to the new server(2005).and What about the jobs and SSIS(DTS) Packages.Thanks
View 5 Replies View RelatedCurrently I'm working on my Desktop computer but I wanna put all my data to my laptop so that I could continue my work on my laptop.
How can I transfer my SQL Server database to my laptop?
Anybody can give me a reference about how to move database from Oracle to Sql Server.
View 2 Replies View RelatedI am running SQL Server 2000.
I have about 300 tables scattered across 3 databases that I am trying to consolidate into a single database. There are other tables within these 3 databases that I don't wish to consolidate (so I don't want to copy the full database).
What are my options to move these tables to the consolidated database?
Are there options beyond, the pain and extensive run-time of copying from the DTS wizard into the new database (plus the indices won't copy will they?) or writing code that creates tables in the new database, populates them with data from the old tables and then deletes the old tables?
My understanding is sp_rename won't work with two separate databases --i.e., your destination db must be the same as the db of the object you are renaming. (if my understanding is wrong, that would seem to be the easiest way to accomplish this)
Thanks,
Is there a way to move the Distribution database (that is currently on the publisher server) to a different server without having to reync the subscriptions.
View 0 Replies View RelatedI have a question here.
I have a Audit tables database. I want to archive the Audit Tables data to another new database in the same server and remove the data in the Actual database but continues with the table seed where it's the primary ID.
Example:
I have a AuditProducts Table with AuditID as BIGINT and auto increment value.
contains10,000 records in AuditTable Database.
I want to archive the tables to a new database: Audit200707
After archived, the AuditProducts Table in AuditTable database will remove all the records and continues with 10001 in the next record.
How can I done the whole process using T-SQL so that it can schedule and run for every month? BTW I am using SQL Server 2005 SP2.
Thanks and regards,
HI guys!
I have a Japanese sql server installed in one server..
I want to transfer everything to an English SQL Server version.
Will this be no problem?
Hope you can enlighten me on this one...
Thanks!
How to import database in SQL server 2005 from the SQL server 2000 ??
Can anyone refer me to good 'recipes' or sources of information on thistopic??I have Visual Studio Tools for Office, which installs SS 2005 Expresslocally to my XP box, and I want to develop in SS 2005, then copy thetables or queries or reports etc. to a SS 2005 Standard server.Thank you, Tom
View 3 Replies View Related
Hi,I need to know the way in which I can copy my sql server 2005 database from one computer to another ?
Please I need a clear and complete explanation ,thanx .
I am moving a database from one server to another. I am going to replace the old server to the new one. I heard that you can move the datfiles and put them in the same directory, and sql server will pickup the datafiles based on the system tables. Is this possible, and what are the steps to get this to work. Thanks for the help in advance.
View 4 Replies View RelatedI want to to move all database log files from drive E to F .
There are more than 10 databases so I don’t wanna move them 1 by 1 .
At the moment I use detach – attach method .
-Detach db
-Move log file
-Attach db
How do I do this massively in one go ?
Hi all! I know I might sound stupid, but I have this problem. I have developed my database on my laptop which does not use Active directory. Lets say I access the database with: SPIDERMANDB1 on SQL server, where the name of my laptop is SPIDERMAN, and the database is DB1. Now, I create an SQL script from sql server and make the necessary changes, like changing the computer name to say, SUPERMAN where my deployment server's name is SUPERMAN. But when I run the SQL script on the SUPERMAN server, it gives me an error like: "User or role SUPERMANDB1 does not exist in this database". I have deployed databases in this way on servers without Acive directory, so I'm sure its not a mistake on my side. So how am I supposed to go around this active directory thingi! Please help me out! I'm counting on u guys!
Wes
I'm trying to find a way to insert data from a TableA on ServerA into TableB on ServerB using SSIS in Visual Studio.
The specification I was given is basically
Insert INTO TableB AS (Select * from TableA WHERE NOT EXISTS on TableB).
I can't use a linked server unfortunately.
I wonder if it possible to move data from tables on a linked server to a "normal database"? What am I doing wrong?
Hi,
We have an old machine which holds SQL server 2000 database. We need to migrate a whole database to a new machine which has SQL server 2005.
When we tried to move whole database using Import and Export Wizard, only tables can be selected to import/export. However we want to import/export the whole database, including tables, stored procedure, view, etc. Which tool should we use?
Thanks.
Hi,
We have an old machine which holds SQL server 2000 database. We need to migrate a whole database to a new machine which has SQL server 2005.
When we tried to move whole database using Import and Export Wizard, only tables can be selected to import/export. However we want to import/export the whole database, including tables, stored procedure, view, etc. Which tool should we use?
Thanks.
I am using SQL Server 2012 SE.I am trying to delete rows from a couple of tables (GetPersonValue has 250 million rows and I am trying to delete 50Million rows and GetPerson has 35 Million rows and I am trying to delete 20 million rows). These tables are in TX replication.The plan is to delete data older than 400 days old.
I tried to move data to new tables from the last 400 days and it took me like 11 hours. If I delete data in chunks of 500000 then its taking a long time to rebuild indexes(delete plus rebuild indexes 13 hours). Since I am using standard edition partition wont work.
find ddl below:
GO
CREATE TABLE [dbo].[GetPerson](
[GetPersonId] [uniqueidentifier] NOT NULL,
[LinedActivityPersonId] [uniqueidentifier] NOT NULL,
[CTName] [nvarchar](100) NULL,
[SNum] [nvarchar](50) NULL,
[PHPrimary] [nvarchar](50) NULL,
[code]....
Hi ,
I'm moving all objects of one database 'A' to another databse 'B' in the same server.
There are common users under both the database.
How can I ensure that the database users get the same roles and persmission on the new objects(Moved through DTS) in 'B' .
Pls help
Thanks,
Kavitha
I'm trying to move specific data from three linked tables on a source database to three tables on a destination database by generating dynamic SQL INSERT scripts but am getting stuck on the last set of INSERT statements. I don't think I can use SSIS because the source autonumber fields may already exist on the destination side but I could be wrong.
For simplicity, Table 1 (T1) has one autonumber key of PK1 as well as other fields (A1, B1, etc.).
Table 2 (T2) has one autonumber key of PK2 and a foreign key (FK1) that links back to PK1 as well as other fields (A2, B2, etc.).
Table 3 (T3) has one autonumber key of PK3 and a foreign key (FK2) that links back to PK2 as well as other fields (A3, B3, etc.).
Like this:
T1: PK1, A1, B1, etc.
T2: PK2, FK1, A2, B2, etc.
T3: PK3, FK2, A3, B3, etc.
So, I'm able to query the source database T1 to generate my dynamic SQL INSERT statements that will be run on the destination side. I'm also able to generate my dynamic SQL statements to insert into T2 but when I get to T3 I currently am stuck figuring out how to insert because the destination side is unable to match it's FK2 to the just inserted PK2. It throws the below error.
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
I have 2 instances of SQL-Server 2000 running on my computer.
I connected to them through SQLServer enterprice Manager.
Now I want to connect to a Database that is stored on my WebHosting-Site [on INTERNET]
The Server-IP address is 65.22.42.57.etc..........
WHILE I can connect to That Database from Visual-Studio server-Explorer..........I cannot connect to that server from SQLServer-EnterpriceManager.
It says 'You need to use SQLServer 2005 tool'.
But there is no Connect-word to create a connection in 'SQLServer 2005'-Manager.'
HELP I need to connect , what shall I do ?
EXPERTS.
I was wondering if any body has used Internet as a WAN (Wide AreaNetwork) to provide database access. I know about web services but Ilike to experiment with using Internet as a extended network (webserver behind one router and database behind another). Any ideas onwhere to look for this?Thanks
View 3 Replies View RelatedHi all,
There is a sql express database .mdf file which I can access locally through local web pages using windows authentication and integrated security = true.
Now I want to publish this db and the web pages to my hoster's server so as to access the db from internet.
The connection string currently is in the web config as below:<add name="NORTHWNDConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|NORTHWND.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" /> The database is currently located in the App_Data folder.
Please give me some step by step solution to configure the db to access from internet. Thanks a lot in advance.
I have been building ASP, ASP.NET and Crystal Reports on SQL serverfor a few years now.I have build them mostly on an Intranet or with companies that havetheir own web servers.I now need to build an application for a company that doesn't not havea web server. Just a small shop that wants an internet application.How do I build an database application when the site will be host byan ISP? The database will be SQL Server 2000, but located locally.The site will be maintained by the ISP? How does the an applicationhosted by an ISP interact with a database located locally (client'ssite)?If someone could point me toward some tutorial or tell me how to dothis, I would appreciate it.
View 1 Replies View Related
Hi,
I wanna attach to the database from our domain(ftp site) . it is not in the our network..
thanks,
J
Hie !
Please, how to manage (attach,connect to) MySql database located on host server http://www.avanti.si from my home PC with Microsoft SQL Server Management Studio Express? This "http://www.avanti.si:8080MySqlDatabaseName,3306" fail !
Thenks!
Hi, I've spend quite a bit of time on this but no luck. so any help is really appreciated.
I'm writing a class library dll that would pull data from a central db to offsite comps, manipulated then updated it back to the central db, much like systems salemen would use. Please keep in mind that i'm talk about LARGE amount of data. I want downloaded data to be manipulated on the client computer(without direction connection to db server) with EXCEL or something of the likes then upload changes back to the central DB.
Is there anything in SQL Integration Services that would help me? please keep in mind that data are distributed to computers over the internet, not on the same LAN. Please be as specific as possible
i'd really appreciate any help you guys can provide, thanks.
Vu,
i have created site on asp.net using database sql server 2000 . i want to upload database and tables on internet. But i dont know how to do that.
Please help me. i have very less time.
I create a WebSite onto the internet.
Then I created a database with MSSQLmanager provided by the WebHosting.
I created a Table and put some data in it.
When I try to access the DataBase an Error says: "Connection cannot be opened. On default settings you cannot access a Database Remotely."
What shall I do to configure my Database.
basically I don't know where to go to change configuration of my Database.
In my intranet I would use SQLServerSuraceArea.
But on Internet I do not know.
someone Help.
Did I miss something ?
How can I store my database on the internet and then access it's data (from a Visual Basic Express Windows Application)?
Where on my server do I upload it to?
How do I keep it secure?
Can anyone reccomend any good articles, etc, please?
Thank you for your help.
Sam
guys,I have a project need to move more than 100,000 records from onedatabase table to another database table every week. Currently, usersinput date range from web UI, my store procedure will take those dateranges to INSERT records to a table in another database, then deletethe records, but it will take really long time to finish this action(up to 1 or 2 hours).My question is if there is some other way I should do to speed up theaction, I am thinking about use bcp to copy those records to datafileand then use bcp to insert it into SQL Server table. Is this the rightway to do it or should I consider other solution (then, what is thesolution.)Thanks a lot!
View 8 Replies View Related