Hi ,
We have a sqlserver 6.5 and sqlserver 7.0 on separate machines.
We cannot upgrade the 6.5 to 7.0 as of now since we have certain projects still running on that box.
However,we would need to push and pull data across the servers.
Could we setup replication across the instances?although they are of different versions?
Thanks and Regards,
Mandar
Hi,
We have few branches with individual dbs are sitting in the branches itself. Periodically all the data need to be updated to a single HQ database. At the moment, all the tables's primary key are unique and each branch will have branch ID's in the transaction tables.
e.g. Branch1 data need to be updated to HQ db. However, HQ db records which are related to Branch 1 data only need to be updated back to Branch 1. other branch records should not goto Branch1.
Similaryly other branch records need to be updated/replicated back to HQ database. And only records related to the particular branch need to be updated from HQ (if any changes made)..
At the moment, i can do simple replication from one db to another db only... Can anyone guide/give suggestions on how to go about doing this?? If possible, please give steps involved...
TX
Hi, How can i calculate the date out? i am using vb sql server database...db saved my date as dd/MM/yyyy, form display my date as dd/MM/yyyy too
1.I have a selected date by user from calendar in tb_dop.text
2.creditDate.text for user to enter number of days to add to tb_dop.text date
3.dDate.text to display the calculated date Private Sub Calendar1_SelectionChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Calendar1.SelectionChanged
'display selected date from calendar
tb_dop.Text = Calendar1.SelectedDate()
End SubPrivate Sub btn_add2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_add2.ClickDim myDate As New DateTime
myDate = tb_dop.Text
Dim i As Integer
i = creditDate.TextDim dDate As New DateTime
dDate = myDate.AddDays(i)
dueDate.Text = dDate
ERROR
The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.The statement has been terminated.
I know it is becos diff format of date calculation, there4, how can i change it to calculate in mm/dd/yyyy format? Funny rite? i can saved and display in dd/MM/yyyy but i cant calculate using this format
Note: i cant change my form display format to mm/dd/yyyy cos i need it to be user friendly in my country ty (URGENT)
Once again thanks
Is there any way to restore a database of higher version to lower version.
E.g. I have created a database in sql server 2012, created some tables & procedures in that.I took Full backup of that database. Can I restore it to sql 2008r2 or any lower version.
I know direct restore is not possible, I have to use either import or export option or generating script,but i want to know is there any easy step to do so.
Vimal Lohani
SQL DBA | MCP (70-461,70-462)
Hi all,
Since some analysis services features are only available in Enterprise version , I have to upgrade my SQL 2005 server from standard edition to enterpise edition.
So I uninstall originial standard version of analysis service and install a Enterprise version. However, the analysis service is still a standard version after installation.
Is it possible to keep data engine as standard version and install a enterprise version of analysis service?
Thank you very much
Tony
Hello,I have been searching and reading a lots of information on the microsoft website about the different version of SQL server, but still can not make my decision.In term of performance, is there a real big difference between the workgroup and the standard version? The workgroup is limited to 3 GB of RAM while the standard is unlimited, would that really change the performance if my server has 16Gb or RAM?The price difference is pretty substantial so if could only have to buy the workgroup , it would be better.One more question, regarding the type of licence, my server has 2 processors, could I avoid buying 2 licences and get the Server plus CAL instead. I am using this server to host 4 web-application running on SQL server. Each database is about 15 MB.Thanks in adavance for your advises.Arno
View 3 Replies View RelatedI am wondering if it is possible to change from SQL Server Enterprise Evaluation Version to Developer Version. The reason is because the Enterprise Evaluation version expires after 180 days. So if I create reports and cubes in Enterprise Evaluation I can import them into Developer Edition right? Should I remove the Enterprise Evaluation version after 180 days or leave it then install Developer Edition?
View 1 Replies View RelatedHi,
I have tried to attatch a database ,created by SQL server Express within a C# application , in SQL server 2005 Enterprise edition, but the following error message appears:
-----------------------------
TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server 'MEDO'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft SQL Server&ProdVer=9.00.1187.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach database+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The database 'E:X.MDF' cannot be opened because it is version 611. This server supports version 607 and earlier. A downgrade path is not supported.
Could not open new database 'E:X.MDF'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)
------------------------------
so , how can I solve this problem , I need to reed the data resides in the tables of 'X' database , how can I do it?? please help me.
Thanks in advance for any help.
Aya.
Hi i have tried a search on this topic but didn't find much.
I have my fiest sql db live on my we server and all works fine, more luck than skill i think.
But now i wory about backing up my data i have tried various tools backing up the db every 5 minutes and then sending it too another server via ftp this tool works fine but when we have a few people on and the db is accessed frequently it can't back it up i assume this is to do with the backup tool needing an exclusive lock on it.
What is the difference between Replication and data mirror both of these seem to be talked about alot and is there a simple guide somewhere on how to set these up.
Or if i am coming at this from totally the wrong angle then please let me know
Thanxs
Hi all.
Any assistance regarding this would be greatly appreciated.
We are currently in the process of setting up replication, and I need to do some testing prior to putting this into production.
I would like to test the replication using SQL Server 2005 Standard edition as this is the version we will be implementing on our servers. My question is this - is there a trial version of the Standard Edition as my understanding is that the trial version that can be downloaded from Microsoft's website is the Enterprise Edition. If it is the enterprise edition, I am concerned that my tests will not be a true reflection of our proposed systems.
Does anyone know where I can obtain the Standard Edition trial version?
Many thanks.
What is the minimum SQL Server version I can use on my replication distributor server? My publisher and subscriber(s) will all be Enterprise Edition (64 bit). However, it seems awefully wasteful to put Enterprise Edition on a box that is just used for distribution. That's another $15K for a server that doesn't do much. Can I use a lower version (Express, Developer, Standard)?
Thank you,
Ben Wolf
We want to licence a trail version 2005 EN with an fullversion of MS Sql server 2005 EN. Is that possible?
Conworx
We have a 64bit os machine that we accidently loaded the 32 bit version of sql server on. We now want to upgrade it to 64 bit sql server, but we now have a production database on it. My understanding is that all I have to do is detach the production database, upgrade to 64bit sql server, then reattach the database. Is this really all I have to do?
View 4 Replies View RelatedCan some one here give me more insight about how to upgrade a SQL Server 2005 Standard Version (32 bits) to a SQL Server 2005 Enterprise Version (32 bits) as default instance on a Windows 2003 enterprise OS (32 bits). I want to know what is the easist way and what is the safest way. May I preserve some settings I have for the STD version, or I have to start from strach again to configure the server? Is there any catches, anything I should have attention to (We are using heavily about CLR and fulltext indexing)?
Thanks a milliom
Ning
Does anyone know how to get SQL Server versions, Service pack versionsand the Server that instance of SQL is running on a network. I haveseen some threads on how to list SQL servers in a network but I need tofind more info about these SQL servers.Any help appreciated..!Thx...
View 1 Replies View RelatedHello,
I installed the SQL Server 2k EnterPrise version and developer version on the same version, and the developer version is an instance "Development".
How do I expose both of them to internet? Just open both of them to port 1433? And on the client side, just say IP and IP/Development? Do I need specific set up, will they conflict?
Thanks,
I downloaded the 101 Samples installation (i.e. 101SamplesCS.msi) from Microsoft's website, which contains SQL Server database files.
While working with the databases in the "Data Access" samples from the 101 Samples projects, I get the following error:
"Database <mdf_name> cannot be upgraded because its non-release version (600) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must re-create the database..."
I assume the database files were created with a beta or CTP version of SQL Server 2005. Does anyone know where I can get an updated version of these database files or scripts to update them?
Please help.
Mike.
Hi,
I am configuring replication and i started using wizard . i opened publishing and distributor wizard and click on next it is saying that "Sql manager could not complete wizard because @@sername is null and use sp_add server name to set @@ servername.
This is productionbox. Any body help me how to fix the problem and what is that meaning osf error.
Thanks
While setting up replication i get a following error..
I am using publisher + distributor on one server
and subscriber on other server
I am getting the following error
"The process could not connect to Subscriber '<Server_name>'"
Any Ideas..
Thanks in advance
VIk
Hi Guys,
We are using transactional replication, I want to add a filter on the rows.
Can Any one explain me how to add it. To do this we should stop replication and then add the filter ???.
Thanks in advance
Hi Guys,
I am having around 1000 tables, in which around 700 tables are not having primary keys on the tables, The tables which are not having primary key, i want to set up an snap shot replication, Tables with primary keys with transactional replication. can i have both transational as well as snap shot set up on the same server????
Thanks
hari
I have setup the snap shot replication on one table.It says the initial snap shot not yet available.What does it mean?How to activate the replication?
Thanks.
Hello there,
I need some urgent help on the Replication .....SQL 6.5, sce 5a, windows NT4.0
A Publication has been installed between 2 server (SQL 6.5, sce pack 5a).
The task Repl_Subs_Distribution fails with the following message:
"The last distributor job id and the last subscriber job id do not match. No jobs were available with a job id > 80"
1) with a Push Subscription, the error "no subscriber has been defined" came up, so I also did a pull subscritption for
the remote server = could it be the cause of the job id not matching?
2) although I found a document on a "sp_Mskill_job" replication stored procedure, it is not present in my DB and I cannot
use it. Is there a way to create it?
Thanks for your precious help.
Best regards,
Rachel
I was advised to Compair max job_id in MSsubscriber_status on distribution and MSlast_job_info on subscription and If not match,
to modify the id in MSlast_job_info.
There is no distribution server in this Replication....any other idea or possibility??
Hello Everybody ..
Greetings !!
I wanted information on Transactional Push replication between SQL Servers . I have one table on SQL Server 6.5 and there are certain text in the table with single quotes .
When i replicate this table to SQL Server 7.0 the text appears in double quotes on SQL Server 7.0 .
Can anyone help regarding this problem ? Has it something to do with version problem .? Where can i get more information on this issue ?
Many thanks . An early response will be highly appreciated .
Hello Mr. Paul...
Thank you so much for your prompt response . Is it possible to change the settings of the Quoted Identifiers ? How can we do it in SQL Server 6.5 and SQL Server 7.0 ? Do you have any info. on the same . ?
Thanks once again .
Yatin.
Hi Guys,
I have a database replicated to another database in a remote server.
We have a trigger in one of the tables in remote Database(replicated), which will fire as soon as there is an insert into this table. This trigger is maintaining the business logic. This trigger will insert the records into another table depending on what kind of information obtained from the new row(which was replicated).
Problem is, since we are using replication ( it uses bcp internaly), the trigger is not firing. I some how wanted to add these new records to the other table (automated). Can you guys please advice me on how to implement this.
I appreciate your help
Thanks,
Jeyam
Hi All,
I have been asked to take over the maintenance on dB servers that I have not originally 'set up'. The request came as a result of the database log files growing at such a rapid pace its taking up hard drive space. I ran sp_dboption and noticed that the log files are NOT set up to truncate on checkpoint. As in SQL 2000 I wanted to determine if the dB was set up in 'simple' or 'full' recovery mode. It appears they are set up in 'full' recovery mode (which we can modify, since this is not a transactional dB and we rarely if ever have to restore from the transaction log). Hence my question,
Is there anything I need to worry about (regarding replication)if I change the dboption to truncate on checkpoint and set dB in simple recovery mode?
And after I backup the transaction log and try to shrink it will that have any adverse affects? I feel like this is all I need to do but replication is new ground for me, any information regarding it would be greatly appreciated. Also, any advice on how to maintain the transaction logs would be helpful.
Christine
hi,
I want to setup transactional replication(PULL) between 2 servers .
can anyone guide me with the steps involved while performaing a Pull replication from server1 to server2.
Any help appreciated.
Hi,
I am setting up merge replication between 2 server located at different location on different Domain..Domins have a trusted connection .
When i run the merge agent i get the following error..in error detail.
Last action : - "xp_execresultset: unable to get a bound connection back to
server"
Last Call : - {call sp_MSmakearticleprocs (?, ?)}
Does any one have the idea
Thanks in Advance
Vik
HELP!!!
I need some urgent help. I'm managing merge replication between 12 servers. Today I had to make some changes in the database design, so I removed replication, altered the tables in question (on all servers)and created a new publication.
I choose the option that all subscribers have the data and the schema, but when I start the replication I get almost immediately an error "Invalid column name rowguidcol". But there is no column in my database with such a name. Further investigation brings up another message "xp_execresultset: unable to execute result set".
Can anyone please help me. The database should be ready by tomorrow.
TIA Markus
Hi,
Every one
I have added new column in my Publication - Article Table ,
Same column I have added in my Subscriber Table ,
I am doing Transaction replication , but now its giving me error
Insert Error - Column Name or Supplied Value doesn't Match,
If any one has any idea please suggest me
Thanks
Nirmal
Hi !!
We are using Ms SQLSERVER 6.5 on NT 4.0 service pack 3
I have joined in as a new DBA and don't know much about MS-SQLSERVER & it's replication.
What I have observed out here is that one of the databases was being replicated betnn Tokyo and
Kawasaki and suddenly after 22nd Feb stop replicatiing without giving any errors.
I have checked the max job_id in MSsubscriber_status on distribution database as well as max_job_id
in MSlast_job_info on subscription db.They seem to match.I have also tried to drop and recreate
the unique clustered index on the subscribing database.But nothing seems to work.
can anyone help me with this ?
Thanking in anticipation.
Regards,
Sapna
Hello there,
A Publication has been installed between 2 server (SQL 6.5, sce pack 5a).
The task Repl_Subs_Distribution fails with the following message:
"The last distributor job id and the last subscriber job id do not match. No jobs were available with a job id > 80"
1) with a Push Subscription, the error "no subscriber has been defined" came up, so I also did a pull subscritption for
the remote server = could it be the cause of the job id not matching?
2) although I found a document on a "sp_Mskill_job" replication stored procedure, it is not present in my DB and I cannot
use it. Is there a way to create it?
Thanks for your precious help.
Best regards,
Rachel